Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “throngs” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

258 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
throngs1150816(None) 
thongs104611181th_ongs
thrones105715841thrones
throng10539971throng_
barongs105310832barongs
hongs95126202_h_ongs
prongs94314482_prongs
sarongs84511802sarongs
things104914282th_ings
thong95014172th_ong_
thorns95314092thorn_s
thorons104511912thoron_s
throats104612172throats
throbs118311372thro_bs
throes97518672thro_es
throne98517602thron_e
throned115412172throned
thronged13405332thronged
through141647512through
throws129715232thro_ws
tongs65928462t__ongs
trogs67022602t_ro_gs
tronas63816892t_ronas
trones65629282t_rones
wrongs10338932_wrongs
airings83913833airings
aprons8316993apron_s
barong96015823barong_
barons85025383baron_s
belongs10408223belongs
bhangs12449663bh_angs
bongs87828423__bongs
borings103614243borings
borons85520543boron_s
brings94618433_brings
broncs101611153_broncs
changs125215373ch_angs
chromas142512683chromas
chromes142914933chromes
chromings17286083chromings
chromos142610273chromos
chronic14311413chronic
chronics1538683chronics
chronon1237353chronon
chronons1347353chronons
coronas93916903coronas
crones84729243_crones
darings93713643darings
dethrones1347313dethrones
dongs76525813__dongs
drones75023433_drones
drongo836793_drongo
drongos935493_drongos
dugongs1053253dugongs
earings84517703earings
enthrones12910073enthrones
ethions1038483ethion_s
firings114112323firings
flongs105010493_flongs
frogs96220773_fro_gs
fronds106412343_fronds
frons86124043_fron_s
fronts94415793_fronts
furlongs12304073furlongs
girons75014373giron_s
gongs74921613__gongs
grogs76319413_gro_gs
gyrons105511223gyron_s
hangs95726723_h_angs
herons94820543heron_s
hoggs107212463_h_oggs
hogs87139663_h_o_gs
hones88144493_h_ones
hong85833953_h_ong_
hongi96715853_h_ongi
honks125124523_h_onks
hons77350783_h_on_s
horns86125333_horn_s
inthrones1299663inthrones
irones64724013_irones
irons55324133_iron_s
kalongs1255443kalongs
klongs11436603_klongs
legongs934543legongs
longs65527063__longs
mahjongs2141813mahjongs
morons84919543moron_s
oblongs1033533oblongs
oolongs845953oolongs
orangs74116033_orangs
ourangs8318503ourangs
parangs104314373parangs
parings104219213parings
phones114121213ph_ones
phonos114114793ph_onos
phons105221143ph_on_s
pongs85526343__pongs
prangs94816233_prangs
progs86624153_pro_gs
prong85218113_prong_
pyrones123113303pyrones
rings65029173__rings
rungs611819403__rungs
sarong73914873sarong_
shogs95319703sh_o_gs
shorings12269483shorings
shrines104618693shrines
shrinks14397913shrinks
shroffs1634353shroffs
shrouds1136013shrouds
shrugs10469163shr_ugs
songs67725553__songs
sorings83817253sorings
sprangs104610053sprangs
springs104415923springs
strings84617133strings
strong74914883strong_
takings124512563takings
talons64019423talon_s
tangs65028343t__angs
taring73932283taring_
tarns56433953tar_n_s
tarocs84615663taro_cs
taroks106115283taro_ks
taros55640823taro__s
tarots66422993taro_ts
tarpons92612203tarpon_s
tauons63412673tauon_s
taxons134211503taxon_s
tenons62916603tenon_s
ternes65422903ter_nes
terns55226873ter_n_s
thanes94918983th_anes
thanks134313133th_anks
thegns10547433thegn_s
theines104013233theines
theins95015423thein_s
thens85921833th_en_s
theologs1246153theologs
thing96622963th_ing_
thinks134613353th_inks
thins85826323th_in_s
thiols95112763thio_ls
thionic1238873thionic
thionin1048653thionin
thionins1177923thionins
thionyl1343713thionyl
thionyls1442943thionyls
tholes94919783th_oles
tholos94213003th_olos
thonged12376833th_onged
thorias102312043thorias
thorn85318703thorn__
thorned11479403thorned
thorny12509843thorn_y
thoron94713903thoron__
thorough15684123thorough
thorpes125010353thorpes
thorps113610893th_orps
though139410763th_ough
thous86017253th_o_us
thralls10299043thralls
thraves13469713thraves
thraws129211103thr_aws
threads11419953threads
threaps12488643threaps
threats104311673threats
threeps12687043threeps
threes97117323thr_ees
thrifts1335523thrifts
thrills10398783thrills
thrips11299013thr_ips
thrives134611713thrives
thro77726423thro___
throat94819753thro_at
throaty13428483throaty
throb109816853thro__b
throe89321423thro__e
thrombi14134443thrombi
thrombus1543613thrombus
thronging1435073thronging
throning1238863throning
throve128012393thro_ve
throw118719733thro__w
thrower1386993thrower
throwers14106023throwers
throwing1536723throwing_
thrown1214911443thro_wn
thrums11429123thr_ums
thrusts10226523thrusts
thugs95611993th__ugs
thunks13459033th_unks
thyroids1546003thyroids
tidings93810253tidings
tigons74112253tigon_s
tilings84212793tilings
timings10279303timings
tings65329193t__ings
tiring74023093tiring_
tiros54524893tiro__s
togs57242433t__o_gs
tones56048663t__ones
tong56434353t__ong_
tonga65619683t__onga
tongas74315513t__ongas
tons46553053t__on_s
tonus56324303t__onus
toons55027533t_oon_s
toroids8310643toroids
toros54336193toro__s
torous64319023toro_us
tortonis848743tortonis
tourings9277373tourings
toyons95512133toyon_s
tranks104017763t_ranks
tranqs155210313t_ranqs
trans54933043t_ran_s
trends75513543t_rends
trigs65423063t_r_igs
trines64132563t_rines
troaks104410593t_roaks
trocks123614633t_rocks
trog57628213t_ro_g_
trois57226093t_ro_is
trokes104019263t_rokes
trolls64613943t_rolls
tromps104911703t_romps
trona54118953t_ron_a
trone55131863t_ron_e
troops85712773t_roops
tropes84824353t_ropes
troths95414153t_roths
trots56629943t_ro_ts
trough108512023t_rough
troughs11698673t_roughs
trouts66116623t_routs
troves94719113t_roves
trows88826183t_ro_ws
troys86418613t_ro_ys
trugs65516803t_r_ugs
trunks10429753t_runks
tubings10336483tubings
tungs65520623t__ungs
turions7311573turion_s
turnings9287233turnings
turnons737863turnons
turns55623233tur_n_s
twangs10358093t_wangs
tyrants1037453tyrants
tyring104613023tyring_
tyronic1239313tyronic
tyros85118593tyro__s
unthrones1297383unthrones
whangs13439723wh_angs
wirings113910103wirings
wrangs104611913_wrangs
wrings104012973_wrings
wrong94712323_wrong_

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.1561145455.1
2DLD Change Limit1340272586.34321129.9
3Display Results2582580.0962687.5
 (SQL Overall)1786912586.59527094.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.