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

168 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
updove123448(None) 
updive1234901updive
uphove1436131uphove
dove85131562__dove
poove104514302_poove
prove104823192_prove
undone7914252undone
unrove92511682unrove
unwove12238882unwove
upbore10247882upbore
update93810292update
updived1434092updived
updives1334712updives
updo76712882updo__
updos8389512updo_s
uprose82311482uprose
uptore8279452uptore
above105414323_above
adobe84814713_adobe
adore65723673_adore
adoze155713833_adoze
alcove1178083alcove
aldose7311093aldose
appose10411993appose
approve14116603approve
behove14207203behove
clove105619443_clove
codrove1336423codrove
cove95837073__cove
dive85634773__dive
doe47361953__do_e
doge66233803__doge
dole56550003__dole
dome77240733__dome
done55747913__done
dope76038893__dope
dore56353303__dore
dose56442433__dose
dote55442883__dote
doven94718553__doven
doves94728153__doves
doze145829083__doze
drove95518063_drove
endive103310473endive
epidote1037393epidote
epode85114093ep_ode
glove94516293_glove
groove10438873groove
grove95219333_grove
hove107132223__hove
improve1435963improve
indole74516053indole
inwove12167273inwove
love75234763__love
move96630723__move
nodose738883nodose
oppose1039193oppose
outdone8311643outdone
outdrove1236473outdrove
outlove102410243outlove
outmove12238713outmove
parve109824853_parve
pave96133893_p_ave
peeve104915253_peeve
phone105621933_phone
plover115312613_plover
poke105335363_p_oke
pole65951303_p_ole
pome85636693_p_ome
pone65747533_p_one
pooves113914713_pooves
pope85535613_p_ope
pore66451263_p_ore
pose66441733_p_ose
probe94320813_probe
prole74527793_prole
prone75332623_prone
prose75835123_prose
proved125016033_proved
proven114314773_proven
prover113819723_prover
proves114322253_proves
psoae74411623_psoae
puddle103914153puddle
radome9511873radome
redone74820053redone
redrove11249423redrove
remove116115573remove
reprove122911073reprove
rewove126420073rewove
rove75136983__rove
shove114421043_shove
shrove125412233shrove
skydove1842083skydove
splore81611303splore
spode84617703sp_ode
spoke114818663sp_oke
spore75428593sp_ore
stove85220253_stove
strove95014793strove
suppose1137973suppose
throve128012393throve
trove85221923_trove
udo49027303u_do__
udon56017743u_do_n
udons65411463u_dons
udos56619903u_do_s
ugsome934783ugsome
uncover1239003uncover
unde55825483und__e
undee65327273und_ee
undine7817263undine
undo55620153undo__
undock1337703undock
undoer73113043undoer
undoes73917403undoes
undue66715553und_ue
unglove1136103unglove
unlive92712333unlive
unloved112310533unloved
unmoved13248903unmoved
unproved1457533unproved
unproven1365463unproven
unrobe82611673unrobe
unroven10238143unroven
unwoven13176673unwoven
unyoke1367293unyoke
upboil1096453upboil
upborne11255133upborne
upbow1245613upbo_w
upbows1384683upbows
upbye1244793up_bye
upcoil10126193upcoil
upcurve1463273upcurve
updart9310743updart
updated11369423updated
updater10347253updater
updates10329793updates
updried11226473updried
updries10209083updries
updry1135483upd_ry
upfold12124953upfold
upgaze1833543upgaze
upheave1544023upheave
uphold12126903uphold
uphroe1136083uphroe
upload9257783upload
upmost1068193upmost
upo58925863up_o__
upon65817583up_o_n
uppile10178503uppile
uprate83916543uprate
uprise82313693uprise
upriver12196933upriver
uproar8106933uproar
uproot8314123uproot
uprouse937223uprouse
upside9289803upside
upsize17267303upsize
upslope1144173upslope
upsoar8105683upsoar
uptake1236963uptake
uptime1067673uptime
uptorn8268093uptorn
uptoss836093uptoss
uptown11274963uptown
vadose1037963vadose
wove105624313__wove

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.1401276364.3
2DLD Change Limit1127161685.45620659.1
3Display Results1681680.0433907.0
 (SQL Overall)1786911685.63931688.4
 
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.