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 “thrower” 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.

273 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
thrower138699(None) 
throwers14106031throwers
crower114117552_crower
grower104614932_grower
prower114218122_prower
rower85430492__rower
shower124315102sh_ower
thawer12489342th_awer
thrawed1435582thrawed
thriver13479122thriver
throbber1543202throbber
throe89321422thro_e_
throes97518672thro_es
throne98517602throne_
throned115412172throned
thrones105715842thrones
throve128012392throve_
throw118719732throw__
thrown1214911442throw_n
throws129715232throw_s
throwster1542952throwster
tower85729202t__ower
trover95014662t_rover
trowed104714652t_rowed
trowel94211462t_rowel
airpower1343983airpower
arrowed1148103arrowed
avower1236823_avower
blower115316573_blower
borrower1384833borrower
bower107328183__bower
brawer114216333_brawer
brewer114812543_brewer
broker124314243_broker
browed125216393_browed
browner124911643_browner
browser124911143_browser
burrower1374263burrower
caroler93816753caroler
chawer144314413ch_awer
chewer145512613ch_ewer
choker154314373ch_oker
choler113717153ch_oler
chooser124412973chooser
chowder16387803ch_owder
chowed154914643ch_owed
chrome133214813chrome_
chromed153510923chromed
chromes142914933chromes
chromier1538033chromier
coroner94218203coroner
cower104531773__cower
crowder13389843_crowder
crowed124717293_crowed
crowers124614893_crowers
crowner124012593_crowner
crozer175112843_crozer
dethroner1344483dethroner
dower95027703__dower
drawer104711363_drawer
droner74717673_droner
drover104614593_drover
drowner11369803_drowner
embower14267403embower
empower14217033empower
endower1138483endower
enrober9218623enrober
flower124815503_flower
frowner13429683_frowner
furrower1464033furrower
glower105114933_glower
grocer94212143_grocer
groper94517253_groper
growers113612723_growers
growler11318973_growler
harrower1446363harrower
hewer115719933_h_ewer
hoer76533983_h_o_er
homer105828453_h_omer
honer85332093_h_oner
hoofer124014953_hoofer
hooker134820173_hooker
hooper114518313_hooper
hooter94123923_hooter
hoover124314433_hoover
hoper105829143_h_oper
hoser811529763_h_oser
hover115524133_h_over
howe106734103_h_owe_
howes114730263_h_owes
howler123514313_h_owler
imbower14235663imbower
impower14247123impower
ironer64216453_ironer
knower1337073_knower
kotower1434383kotower
kroner104612573_kroner
lower85830413__lower
mower104523453__mower
narrower1145063narrower
plower114315063_plower
power105325953__power
prober104516073_prober
proper104319953_proper
proser84223463_proser
prover113819723_prover
prowar114110943_prowar
prowler123310013_prowler
rawer84623733__rawer
repower12329883repower
roger64521413__roger
roper75431913__roper
rover85527373__rover
rowed94034323__rowed
rowel84721413__rowel
rowen84921153__rowen
rowers94924573__rowers
screwer124410063screwer
shadower1544863shadower
shewer124515103sh_ewer
shoer84722153sh_o_er
shooter103013983shooter
shorter103515493shorter
shover124515983sh_over
showed135016963sh_owed
showers134612673sh_owers
showery16437233sh_owery
showier1339093sh_owier
shrewder1534393shrewder
shrewed14589843shrewed
shriver134712193shriver
shrove125412223shrove_
slower94016153_slower
sorrower1165033sorrower
sower85229313__sower
strewer104310403strewer
stroker114113523stroker
strowed115312143strowed
stroyer103510783stroyer
taborer9269293taborer
tardier859719993tardier
tarrier74323173tarrier
tarsier74119253tarsier
tarter64023563tar_ter
tartier74123263tartier
tawer85223443t__awer
tenoner739683tenoner
termer85717253ter_mer
terrier73414963terrier
terser67317823ter_ser
thaler94613103th_aler
thalweg1442033thalweg
thanker14309593thanker
thawed13458463th_awed
thawers13428483th_awers
theater104014253theater
theorem1236263theorem
thewier1336063thewier
thicker163611023thicker
thinker143610683thinker
thinner10358973thinner
thirster1135673thirster
thither13328103thither
thole85620843th_ole_
tholed105113873th_oled
tholes94919783th_oles
thorned11479403thorned
thornier1135323thornier
thorpe113610093thorpe_
thorpes125010353thorpes
those85218143th_ose_
thoued10429003th_oued
thrasher1455743thrasher
thrave126010273thrave_
thraves13469713thraves
thraw1110515923thraw__
thrawart1445163thrawart
thrawn12769423thraw_n
thraws129211103thraw_s
threader1256733threader
threaper1345143threaper
three87526913thr__ee
threep115910113thr_eep
threes97117323thr_ees
thresher1455823thresher
threw1117315713thr__ew
thrice114311573thrice_
thriller1165553thriller
thrive125313223thrive_
thrived14458183thrived
thriven13447023thriven
thrivers14456823thrivers
thrives134611713thrives
thro77726423thro___
throat94819753thro_at
throated1247923throated
throatier1244543throatier
throats104612183throats
throaty13428483throaty
throb109816853thro__b
throbbed1643163throbbed
throbbers1643173throbbers
throbs118311373thro_bs
thrombi14134453thrombi
throng10539973thro_ng
thronged13405333thronged
throngs11508163throngs
throttler1262863throttler
through141647513through
throwing1536723throwing
throwsters1642703throwsters
thrummer1542933thrummer
thruster1135793thruster
thruway1643163thruway
thumper14356953thumper
thunder1136963thunder
thurifer1443273thurifer
thymier1534393thymier
tireder837703tireder
toker95924913t__oker
toner55336243t__oner
tooler63818613t_ooler
tooter64420803t_ooter
toper75231023t__oper
torose64317693torose_
torquer16205323torquer
toter55932133t__oter
towed95134583t__owed
towel84920523t__owel
towers94423673t__owers
towery124012093t__owery
toyer84521553t__oyer
tracer84820233t_racer
trader75218763t_rader
trawler104011903t_rawler
trier54328533t_r_ier
trimer85717153t_rimer
triter65120593t_riter
trocar848773t_rocar
trode65322853t_rode_
troffer13125863t_roffer
troke94821053t_roke_
troked114114583t_roked
trokes104019263t_rokes
troller73913173t_roller
trone55131863t_rone_
trones65629283t_rones
trooper94210363trooper
trope75725803t_rope_
tropes84824353t_ropes
trotter73312253t_rotter
trouper93811433t_rouper
trouser73812473t_rouser
trove85221923t_rove_
trovers103713323t_rovers
troves94719113t_roves
trow78031423t_row__
troweler11106063t_roweler
trowels10358363t_rowels
trows88826183t_row_s
trowsers11428003t_rowsers
trowth1277883t_rowth
truer54916643t_r_uer
turfier10249793turfier
turner63914613tur_ner
turnover1143593turnover
turtler72610323turtler
tutoyer1033793tutoyer
twofer1234353t_wofer
vower115220793__vower
warpower1645043warpower
whooper15297153whooper
widower1435343widower

Search took 8 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 Limit1340272736.97019229.1
3Display Results2732730.1102481.8
 (SQL Overall)1786912737.23624694.7
 
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.