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

146 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
reshoots1122841(None) 
reshoot102513891reshoot_
beshouts1346762beshouts
reboots93512092re_boots
redroots937752redroots
reschools1444082reschools
reshoes102316032resh_oes
reshot93519632resh_ot_
reshows132510452resh_ows
resmooth1343632resmooth
resmooths1442642resmooths
resorts74817192res_orts
respools1036252respools
respots92912762res_pots
shoots94619362__shoots
upshoots1344232upshoots
beshout12311843beshout_
besmooth1543353besmooth
besmooths1642593besmooths
besots86415453bes__ots
bhoots11459913__bhoots
cahoots1238473_cahoots
cashoos12310793cashoo_s
crapshoots1753063crapshoots
dashpots1444193dashpots
dehorts11379773de_horts
despots10319683des_pots
disroots948633disroots
enroots738713_enroots
escorts9418403_escorts
escots84211743_es_cots
exhorts1746313_exhorts
eyeshots1453373eyesh_ots
festoons1136443festoons
fleshpots1742603fleshpots
freeboots1444043freeboots
freshets14298673fresh_ets
hoots84830253___hoots
offshoots1851773offshoots
outshoots1245393outshoots
overshoots1644393overshoots
preschools1753833preschools
preshows16267023presh_ows
presorts105311683pres_orts
readopts1146493readopts
readouts938903readouts
reallots837993reallots
reaphooks1843333reaphooks
reassorts945623reassorts
reblooms1244283reblooms
rebooks134010513re_books
reboot84119333re_boot_
recharts1337663recharts
recheats1339193recheats
rechoose13137353rechoose
rechooses14107623rechooses
recoats92616643re_coats
recooks134711233re_cooks
redcoats1147123redcoats
redouts81411663re_douts
redroot8312903redroot_
redshifts1642573redshifts
redshirts1342903redshirts
redwoods1345773redwoods
refloats1156913refloats
refloods1245553refloods
refronts1137773refronts
regrooms1196013regrooms
reheats104513523re_heats
reknots1136783re_knots
relooks114010723re_looks
replots93412633re_plots
reports94916213re_ports
repots85621003re__pots
reproofs1346063reproofs
reroofs1037943re_roofs
reschool1344133reschoo_l
rescores105415693rescores
reseats74319583res_eats
resects94115593res_ects
resents74221223res_ents
resets65427613res__ets
reshapes1338803reshapes
reshaves1438733reshaves
reshes94124363resh__es
reshines112615443reshines
reships1239863resh_ips
reshod103012233resh_o_d
reshoe92816483resh_o_e
reshoed112212153resh_oed
reshone102414163resh_one
reshooting1436223reshooting
reshow123111433resh_o_w
reshowed15117063reshowed
reshower14107063reshower
reshowers15145473reshowers
reshown13257903resh_own
resifts10378703res_ifts
resights1246733resights
resinous838503resinous
resists74414923res_ists
resits64725563res__its
resmelts1046143resmelts
resoaks1148973res_oaks
resods74116303res__ods
resojets1535343resojets
resoles73823653res_oles
resorbs95010523res_orbs
resort65728623res_ort_
resows93915353res__ows
respects1247703respects
resplits1037723resplits
responds1136913responds
respool937643respoo_l
respot83117633res_pot_
resprouts1174823resprouts
restarts8310873restarts
restocks1437503restocks
restokes125213043restokes
restores85222993restores
restrooms1146043restrooms
rests54935873res___ts
results739833res_ults
retools73411023re_tools
retorts76016513re_torts
revolts1038893re_volts
rimshots1343883rimsh_ots
roots55933673r___oots
roseroots945313roseroots
scoots85315943__scoots
seaboots1047093seaboots
shoats94117083__shoats
shooks134515633__shooks
shools94919013__shools
shoos84226363__shoo_s
shoot84235913__shoot_
shorts95321743__shorts
shots84730853__sh_ots
shotts93614703__shotts
shouts94017723__shouts
snoots64216683__snoots
soots55536213__s_oots
testoons837323testoons
upshoot1256693upshoot_
upshots1235193upsh_ots
washouts1445903washouts

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621467.19020328.5
3Display Results1461460.0632317.5
 (SQL Overall)1786911467.67323288.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.