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

402 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
throve12801239(None) 
shrove125412231shrove
thrave126010271thrave
thrive125313221thrive
throe89321421thro_e
throne98517601throne
trove85221921t_rove
chrome133214812chrome
drove95518062_drove
grove95219332_grove
hove107132222_h_ove
prove104823192_prove
rove75136982__rove
shove114421042sh_ove
shrive125216952shrive
strove95014792strove
thieve1235962thieve
thole85620842th_ole
thorpe113610092thorpe
those85218142th_ose
thraves13469712thraves
three87526912thr_ee
thrice114311572thrice
thrived14458182thrived
thriven13447022thriven
thriver13479122thriver
thrives134611712thrives
thro77726422thro__
throat94819752throat
throb109816852thro_b
throbs118311372throbs
throes97518672throes
throned115412172throned
thrones105715842thrones
throng10539972throng
throw118719732thro_w
thrower1386992thrower
thrown1214911442thrown
throws129715232throws
torose64317692torose
trave85223032t_rave
trode65322852t_rode
troke94821052t_roke
trone55131862t_rone
trope75725802t_rope
trover95014662t_rover
troves94719112t_roves
unrove92511682unrove
above105414323_above
aerobe8412403aerobe
ahorse9311513ahorse
alcove1178083alcove
approve14116603approve
arose55832083_arose
arrive91311793arrive
bathrobe1544413bathrobe
behoove1553773behoove
behove14207203behove
brave104925503_brave
breve105317053_breve
broke116019783_broke
brome94421973_brome
brose75227033_brose
carve106227753car_ve
chive135117623ch_ive
choke145118023ch_oke
choose115116143choose
chore105126763ch_ore
chose105925403ch_ose
chroma132912473chroma
chromed153510923chromed
chromes142914933chromes
chromo132811013chromo
chromy16309903chromy
clove105619443_clove
codrove1336423codrove
cove95837073__cove
crave105626313_crave
crone75231333_crone
crore74922873_crore
croze164719453_croze
curve104920023cur_ve
derive103817043derive
dethrone1247563dethrone
dhole95215363dh_ole
dove85131563__dove
drave95219273_drave
drive95318003_drive
drone65324983_drone
droved114611643_droved
drover104614593_drover
droves105116673_droves
enrobe86610793enrobe
enthrone111110113enthrone
erode64520993_erode
erose55727273_erose
froe75329993_fro_e
frore86218803_frore
froze174515653_froze
furore9410013furore
garote7717953garote
glove94516293_glove
grave94624873_grave
groove10438873groove
grope84821613_grope
groved114413703_groved
grovel104310543_grovel
groves104318103_groves
gyrose105310253gyrose
halve114818923_halve
haole84820083_haole
have106137073_h_ave
heave114521813_heave
helve115018093_helve
hive106029673_h_ive
hoe67562723_h_o_e
hoke115935933_h_oke
hole77553393_h_ole
home98042443_h_ome
hone77549323_h_one
hooved134713123_hooved
hoover124314433_hoover
hooves124815483_hooves
hope96639673_h_ope
horde94623053_horde
horse86132653_horse
hose76547243_h_ose
hovel115017683_h_ovel
hover115524133_h_over
howe106734103_h_owe
improve1435963improve
inthrone1179473inthrone
inwove12167273inwove
irone55126363_irone
krone94018733_krone
love75234763__love
morose85116243morose
move96630723__move
nerve86617373ner_ve
outdrove1236473outdrove
pareve114613013pareve
parole84425253parole
parve109824853par_ve
phone105621933ph_one
phrase11109903phrase
poove104514303_poove
porose84818743porose
probe94320813_probe
prole74527793_prole
prone75332623_prone
prose75835123_prose
proved125016033_proved
proven114314773_proven
prover113819723_prover
proves114322253_proves
pyrone112714473pyrone
pyrope132810533pyrope
rave75542093__rave
redrove11249423redrove
remove116115573remove
reprove122911073reprove
rerose63320843rerose
rewove126420083rewove
rive75537723__rive
robe65335643__robe
rode55844303__rode
roe36861083__ro_e
role45851823__role
rope65542913__rope
rose46148903__rose
rote46249023__rote
roue45941743__roue
roved95323553__roved
roven85521973__roven
rover85527373__rover
roves84834483__roves
sarode75317513sarode
scrive115414943scrive
serve85425963ser_ve
shave114425893sh_ave
sheave124514003sheave
sheeve123412843sheeve
shelve124012763shelve
shive114423423sh_ive
shoe75933443sh_o_e
shone83725983sh_one
shore85432653sh_ore
shote85526103sh_ote
shoved134214283sh_oved
shovel124611323sh_ovel
shover124515993sh_over
shoves124919423sh_oves
shrieve13417683shrieve
shrike134513243shrike
shrine94920053shrine
shrived144712183shrived
shrivel13479403shrivel
shriven13379653shriven
shriver134712193shriver
shrives134416173shrives
shroff1538503shroff
shroud1038773shroud
starve94613743star_ve
stove85220253_stove
strive95020963strive
strobe84513813strobe
strode75215973strode
stroke105116173stroke
tardive1136893tardive
tare45957623tar__e
targe65227093tar_ge
taro46846913taro__
taroc75721643taro_c
tarocs84615663tarocs
tarok97921073taro_k
taroks106115283taroks
taros55640823taro_s
tarot55943933taro_t
tarots66422993tarots
tarre55825633tar_re
telome8311923telome
terce75721843ter_ce
terete6319333terete
terne56426153ter_ne
terrae62915213terrae
terse55026823ter_se
tetrode839343tetrode
thae76825563th__ae
thane86122533th_ane
the67436053th___e
thebe107515433th_ebe
thecae11299653thecae
thee78039063th__ee
theine94814923theine
theme105921733th_eme
thence112010843thence
theorem1236273theorem
theory121098363theory
there87527393th_ere
thermae125310503thermae
therme115814993therme
theroid11313403theroid
these86519013th_ese
thieved1434973thieved
thieves1346903thieves
thine85026863th_ine
thio77225413thio__
thiol87616043thio_l
thiols95112763thiols
tho67433963th_o__
tholed105113873th_oled
tholes94919783th_oles
thong95014183th_ong
thorax1638253thorax
thoria93012893thoria
thoric114314043thoric
thorite10313443thorite
thorn85318703th_orn
thorned11479403thorned
thorns95314103thorns
thorny12509843thorny
thoro86217873th_oro
thoron94713903thoron
thorons104511913thorons
thorp104414263th_orp
thorpes125010353thorpes
thorps113610893thorps
thou76722213th_o_u
thoued10429003th_oued
thous86017263th_ous
thrall93810293thrall
thrash12258363thrash
thraw1110515923thr_aw
thrawed1435583thrawed
thrawn12769423thrawn
thraws129211103thraws
thread105011093thread
threap11569663threap
threat95020463threat
threep115910113threep
threes97117323threes
threnode1255423threnode
thresh12276863thresh
threw1117315713thr_ew
thrift12412043thrift
thrill94910593thrill
thrip103012183thr_ip
thrips11299013thrips
thrivers14456823thrivers
throated1247923throated
throats104612193throats
throaty13428483throaty
throbbed1643163throbbed
throbber1543203throbber
thrombi14134473thrombi
thronged13405333thronged
throngs11508163throngs
throstle1175703throstle
throttle1164083throttle
through141647513through
throwers14106033throwers
thru76818943thr__u
thrum104713633thr_um
thrums11429123thrums
thrush12257483thrush
thrust91911893thrust
thyme134612473th_yme
thyroid1438253thyroid
thyrse1235133thyrse
tirade7311693tirade
tire46143353tir__e
tiro46832363tiro__
tiros54524893tiro_s
toe310166853t__o_e
toke86738493t__oke
tole46052903t__ole
tome67543193t__ome
tone46953743t__one
tope65946383t__ope
tore47359323t__ore
toro48045683toro__
toroid7416013toroid
toros54336193toro_s
torot56139943toro_t
toroth95512963toroth
torous64319033torous
torque15237673torque
torse55833333tor_se
torte55431703tor_te
tote46643673t__ote
towrope1245583towrope
trace75829613t_race
trade65026043t_rade
travel94112983t_ravel
traves94222743t_raves
tree47745813t_r_ee
trevet94818913t_revet
tribe74420273t_ribe
trice75127493t_rice
trike95320163t_rike
trine54734603t_rine
triode75311893triode
triose64715383triose
tripe75425383t_ripe
trite54730033t_rite
trivet93721883t_rivet
troak95213573t_roak
troche113112513t_roche
trock114817603t_rock
trod57627953t_ro_d
trog57628213t_ro_g
trogs67022603t_rogs
trois57226093t_rois
troked114114583t_roked
trokes104019263t_rokes
troll54416533t_roll
tromp95815803t_romp
trompe105611263t_rompe
trona54118953t_rona
trones65629283t_rones
troop76417533t_roop
trooz145016153t_rooz
trop66833303t_ro_p
tropes84824353t_ropes
trot46351313t_ro_t
troth85622203t_roth
trots56629943t_rots
troupe84812433t_roupe
trout57332573t_rout
trovers103713323t_rovers
trow78031423t_ro_w
trowed104714653t_rowed
trowel94211463t_rowel
trows88826183t_rows
troy77429683t_ro_y
troys86418613t_roys
truce75118693t_ruce
true46725853t_r_ue
turnover1143593turnover
turtle63213573turtle
turves94212693tur_ves
twelve1234163twelve
tyre75428253tyr__e
tyro76622363tyro__
tyros85118593tyro_s
unrobe82611673unrobe
unroven10238143unroven
unthrone11128183unthrone
unwove12238883unwove
updove1234483updove
uphove1436133uphove
uphroe1136083uphro_e
uprose82311483uprose
varve115716853var_ve
verve115417723ver_ve
wharve15456203wharve
wherve15568113wherve
whole114418093wh_ole
whore116018043wh_ore
whose114914533wh_ose
wove105624313__wove
wrote84717483_wrote

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127164024.92322895.8
3Display Results4024020.1233268.3
 (SQL Overall)1786914025.41932974.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.