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

127 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
respray123650(None) 
resprays1344711resprays
estray95713332_estray
repay104818452re_p_ay
replay113412922re_play
resay85320542res__ay
respeak1335932respeak
resprang11175842resprang
resprayed1544352resprayed
respread1135432respread
spray106720062__spray
astray95615543_astray
bespeak1544573bespeak
bespread1344183bespread
betray111511443be_tray
bewray14147733be_wray
cesura838763cesura_
cesurae937703cesurae
cesuras958693cesuras
defray1337643de_fray
deray95024183de__ray
descry1256183descr_y
destroy1138153destroy
display1336663display
espial839543_espial
esprit8312843_esprit
espy969373_esp__y
essay867623_es_say
estral64716513_estral
estrays10529403_estrays
misplay1436383misplay
osprey1134883_osprey
outpray12268083outpray
pessary1246873pessary
pray96331533___pray
prepay13310313pre_p_ay
raspy106511703rasp__y
reapply1434323reapply
rebury11349213rebur_y
recarry1245063recarry
redbay1238333re_dbay
redisplay1552173redisplay
redraw10269853re_draw
redry94314363re_dr_y
refry114412463re_fr_y
relay84424673re__lay
remarry1235193remarry
remora8414593remora_
remoras9314073remoras
repark123511713re_park
repays113813973re_p_ays
repeal84718283re_peal
repeat85127213re_peat
replan83215823re_plan
replays12399763re_plays
reply104015853re_p_ly
repro75315913re_pr_o
repros84216003re_pros
reran57329103re__ran
resat55139683res__at
resaw84117253res__aw
resays93714153res__ays
reseal64819643res_eal
reseat64131493res_eat
reseau64216213res_eau
reseda739703reseda_
resedas839123resedas
reserve101011203reserve
resiny94617363res_iny
resoak10311093res_oak
resorb84914353resor_b
resorbs95010523resorbs
resort65728623resor_t
resorts74817193resorts
respace11310913respace
respade1039573respade
respeaks1434953respeaks
respect11412033respect
respell947023respell
respelt9312143respelt
respire9411543respire
respired1148993respired
respires10311903respires
respite9513033respite
resplit9310373resplit
respoke134311283respoke
respond1039113respond
respool937643respool
respot83117633resp_ot
respots92912763respots
respraying1636093respraying
respreads1244523respreads
respring111614063respring
resprout1078783resprout
resprung11164103resprung
restart7320033restart
restoral8810983restoral
restrain8311703restrain
restudy1144763restudy
resupply1552523resupply
resurge839073resurge
resurvey1444823resurvey
retiary1038333retiary
retral64419743re_tral
retry84718083re_tr_y
revery124014213rever_y
rewrap11127533re_wrap
riprap1055513r_iprap
ristra6310713ristra_
ristras7311563ristras
rosary92810353rosar_y
rosebay12135773rosebay
rosery93813283roser_y
rostra6310933rostra_
rostral7311333rostral
spay96631663__sp_ay
splay105816043__splay
sprag86418693__sprag
sprat76635973__sprat
sprays115913643__sprays
spry96819123__spr_y
stray88525573__stray
vesperal1344883vesperal
vespiary1642743vespiary
vestral104111013vestral
vestry1238623vestr_y
whipray1843403whipray

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.780229091.0
2DLD Change Limit1340271276.70319995.1
3Display Results1271270.0462760.9
 (SQL Overall)1786911277.52923733.7
 
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.