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

129 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
respells105633(None) 
resells73313201res_ells
respell947021respell_
presells1058282pres_ells
redpolls1144012redpolls
repeals94014522re_peals
repels84318762re_pe_ls
repolls939052re_polls
reseals73917662res_eals
resell64215202res_ell_
resmelts1046142resmelts
respeaks1434952respeaks
respects1247702respects
respelled1257042respelled
respelt9312142respe_lt
respools1036252respools
retells73211522re_tells
spells84617682__spells
bedells10379363be_dells
bespeaks1643963bespeaks
bonspells1343193bonspells
despoils1145623despoils
dispels10310503dispe_ls
espials937093_espials
expels1547173_expe_ls
fresnels1135233fresne_ls
gospelly1443143gospelly
gospels1035593gospe_ls
misspells1343763misspells
outspells11104603outspells
presell939303pres_ell_
pretells1047333pre_tells
rappels11448803rappe_ls
raspers94415923raspe_rs
reapers93520453reape_rs
rebels84518133re_be_ls
rebills93510623re_bills
recalls92613623re_calls
redpoll1045043redpoll_
redrills956083redrills
reels55333263re__e_ls
reexpels1752503reexpe_ls
refalls103312243re_falls
refeels10379693re_feels
refell94214443re_fell_
refels94618053re_fe_ls
refills103711423re_fills
refuels10399523refue_ls
reheels10298253re_heels
remelts93511493re_melts
reopens939373reope_ns
repeal84718283re_peal_
repeats94316053re_peats
repegs93311943re_pe_gs
repel74921403re_pe_l_
repelled113111583re_pelled
repeller103010393re_peller
repellers11278873re_pellers
repents93717623re_pents
reperks13298093re_perks
repoll8410793re_poll_
rerolls739943re_rolls
resails74616743res_ails
resales74724903res_ales
rescales103414573rescales
reseal64819643res_eal_
reseats74319583res_eats
reseaus74012153res_eaus
resects94115593res_ects
resedas839123res_edas
reseeds84012333res_eeds
reseeks11348623res_eeks
resees63827483res_e_es
reseller83412223res_eller
resellers9299903res_ellers
resends83513713res_ends
resents74221223res_ents
resets65427613res_e_ts
resews94814173res_e_ws
reshes94124363reshe__s
resiles74026543res_iles
resmelt9411773resme_lt
resoles73823653res_oles
respaces12311043respaces
respades1139853respades
respeak1335933respe_ak
respect11412033respe_ct
respelling1347973respelling
respellings1442683respellings
respires10311903respires
respites10513243respites
resplit9310373resp_lit
resplits1037723resplits
responds1136913responds
respool937643respool_
respots92912763resp_ots
resprays1344713resprays
respreads1244523respreads
resters74130403reste_rs
restless82713163restless
restyles1139193restyles
results739833res_ults
retell63813643re_tell_
reveals103812723re_veals
revels94220573re_ve_ls
rewelds11457413re_welds
roselle7310243ros_elle
roselles8310713ros_elles
rostella845493rostella
seashells1243543seashells
sells55134433__s_ells
shells94319523__shells
skells105013783__skells
smells83914743__smells
snells64614203__snells
spalls84217343__spalls
speels85116393__speels
speils84116223__speils
spell75020303__spell_
spelts84614643__spelts
spills84717463__spills
swells93913983__swells
tressels8367653tresse_ls
unsells73210773uns_ells
unshells1145923unshells
upswells1342623upswells
vesperals1443933vesperals
vespers1239033vespe_rs
vessels1035933vesse_ls

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.516346300.4
2DLD Change Limit1461621296.54622328.4
3Display Results1291290.0462804.3
 (SQL Overall)1786911297.10825139.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.