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

173 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
respell94702(None) 
resell64215201res_ell
respells1056331respells
respelt9312141respelt
presell939302pres_ell
redpoll1045042redpoll
refell94214442re_fell
repeal84718282re_peal
repel74921402re_pe_l
repels84318762re_pels
repoll8410792re_poll
reseal64819642res_eal
resells73313202res_ells
resmelt9411772resmelt
respeak1335932respeak
respect11412032respect
respelled1257042respelled
respool937642respool
retell63813642re_tell
spell75020302__spell
bedell93610043be_dell
befell11428713be_fell
bespeak1544573bespeak
bonspell1243163bonspell
despoil1046523despoil
dispel9310323dispe_l
dispels10310503dispels
espial839543_espial
expel1448233_expe_l
expels1547173_expels
fresnel1035893fresne_l
fresnels1135233fresnels
gospel936533gospe_l
gospelly1443143gospelly
gospels1035593gospels
misspell1244303misspell
outspell10125453outspell
prepill1147583pre_pill
presells1058283pres_ells
pretell938243pre_tell
rappel104211953rappe_l
rappels11448803rappels
rasped94715203raspe_d
rasper83917333raspe_r
raspers94415923raspers
reaped94122453reape_d
reaper84223143reape_r
reapers93520453reapers
reapply1434323reapply
rebel73421293re_be_l
rebels84518133re_bels
rebill84713253re_bill
recall83815723re_call
redpolls1144013redpolls
redrill857893redrill
reel45240533re__e_l
reels55333263re__els
reexpel1643183reexpe_l
reexpels1752503reexpels
refall94314393re_fall
refeel93913243re_feel
refeels10379693refeels
refel84920813re_fe_l
refels94618053re_fels
refelt94521423re_felt
refill94514053re_fill
refuel93912623refue_l
refuels10399523refuels
reheel93610823re_heel
reheels10298253reheels
remelt85123123re_melt
reopen8311573reope_n
reopens939373reopens
repeals94014523re_peals
repeat85127213re_peat
repeg84015053re_pe_g
repegs93311943re_pegs
repelled113111583re_pelled
repeller103010393re_peller
repent84728873re_pent
reperk122511773re_perk
repled93319783re_pled
reply104015853re_p_ly
repolls939053re_polls
repped114616723reppe_d
reroll6412683re_roll
resail64418733res_ail
resails74616743resails
resale64025543res_ale
resales74724903resales
rescale93215473rescale
reseals73917663reseals
reseat64131493res_eat
reseau64216213res_eau
resect84424703res_ect
reseda739703res_eda
resee54336333res_e_e
reseed74823293res_eed
reseeds84012333reseeds
reseek103813133res_eek
reseeks11348623reseeks
reseen64318413res_een
resees63827483res_ees
reseller83412223res_eller
resend75016773res_end
resent63833623res_ent
reset55051863res_e_t
resets65427613res_ets
resew84519503res_e_w
resewn9459813res_ewn
resews94814173res_ews
reshes94124363reshe_s
resile64627673res_ile
resiled84621983resiled
resiles74026543resiles
resmelts1046143resmelts
resold73915363res_old
resole64624183res_ole
resoled84119283resoled
resoles73823653resoles
respace11310913respace
respade1039573respade
respeaks1434953respeaks
respects1247703respects
respelling1347973respelling
respire9411543respire
respite9513033respite
resplit9310373resplit
respoke134311283respoke
respond1039113respond
respools1036253respools
respot83117633resp_ot
respots92912763respots
respray1236503respray
respread1135433respread
rested74430783reste_d
rester63832433reste_r
resters74130403resters
restful1038623restful
restyle1038763restyle
result6318223res_ult
resupply1552523resupply
retells73211523re_tells
reveal94115053re_veal
revel84423163re_ve_l
revels94220573re_vels
reweld103711113re_weld
ripely112511153r_ipely
roselle7310243ros_elle
rostella845493rostella
seashell1144103seashell
sell45840613__s_ell
shell84424123__shell
skell94915833__skell
smell74916233__smell
snell54517303__snell
spall74919303__spall
speel74420763__speel
speil75618643__speil
spells84617683__spells
spelt75430193__spelt
spill74821163__spill
swell84815983__swell
tressel73010893tresse_l
tressels8367653tressels
unsell63512543uns_ell
unshell1047113unshell
upswell1242723upswell
vesper1138083vespe_r
vesperal1344883vesperal
vespers1239033vespers
vessel937953vesse_l
vessels1035933vessels

Search took 7 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.406440125.6
2DLD Change Limit1340271736.31321230.3
3Display Results1731730.0463760.9
 (SQL Overall)1786911736.76526414.0
 
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.