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 “sexed” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

156 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
sexed13661854(None) 
exed125420591_exed
hexed165615761hexed
seed55549481se_ed
sered65737291sered
sewed95325161sewed
sexes126126221sexes
vexed165713111vexed
axed128829612_axed
boxed154318612boxed
ceded96118552ceded
cered85227442cered
coxed154322812coxed
deed65340902de_ed
deked115718532deked
deled75326542deled
desexed1636172desexed
dewed105020302dewed
dexes135224512dexes
eked96718022_eked
exec135313942_exec
exes116530812_exes
eyed86623232_eyed
faxed166220532faxed
feed84538902fe_ed
feted94420932feted
feued94715662feued
fixed165416952fixed
flexed17419082flexed
foxed165115212foxed
geed65435502ge_ed
heed86437602he_ed
hewed125619432hewed
hexad164910622hexad
hexer155116682hexer
hexes155123042hexes
jeed125428502je_ed
jewed165114832jewed
kexes166216812kexes
keyed1369382keyed
lexes127225262lexes
loxed135017052loxed
maxed155821192maxed
meed74934702me_ed
meted85424432meted
mewed115218012mewed
mixed155717252mixed
need54934152ne_ed
nixed135714222nixed
peed76239182pe_ed
poxed154817862poxed
raxed135622662raxed
reded74829112reded
reed55549622re_ed
refed93921922refed
rewed95425452rewed
rexes124526952rexes
sabed86526812sabed
saned65636272saned
sated66238532sated
saved95127112saved
sawed95628402sawed
saxes125229342saxes
sayed96127142sayed
seabed95017692seabed
sealed74328362sealed
seamed94823882seamed
seared75232842seared
seated75131052seated
secede93311992secede
seder64826752seder
see35772262se_e_
seeded84520462seeded
seeds64330062se_eds
seedy94821532se_edy
seek85935482se_ek
seel45042982se_el
seeled73922092seeled
seem65438562se_em
seemed95117612seemed
seen46943122se_en
seep66540342se_ep
seeped94317522seeped
seer45547042se_er
sees45361052se_es
segued838512segued
seined74023062seined
seised74218122seised
seized164313652seized
selfed10310912selfed
seme65836652seme_
semen75724102semen
semes75731582semes
send55237292se_nd
sended85121232sended
sene46848052sene_
sensed73918162sensed
sere46153472sere_
serer55935502serer
seres55448892seres
serged84118762serged
served104616812served
seven84118312seven
sever85426052sever
sewer84426212sewer
sex107043222sex__
sexier13310682sexier
sext117338092sex_t
sextet13916872sextet
sexto124415452sexto
sexts125118382sexts
sexy146418022sex_y
shed86536152s_hed
shewed134716182shewed
shied96125492shied
shoed95723012shoed
shred98125612shred
sided74825952sided
sieged85212712sieged
sieved104611442sieved
siped84927682siped
sired66134282sired
sited65130742sited
sixes124526362sixes
sized155519242sized
skeed105018982skeed
skewed145610232skewed
skied104417752skied
skyed13529922skyed
sled55334372s_led
slewed104815522slewed
slued64220512slued
sned56026052s_ned
soled65835172soled
sored66141782sored
sowed94933862sowed
spaed85522272spaed
sped76031492s_ped
speed85526622speed
spewed125512332spewed
spied85427712spied
spued84918472spued
steed66024942steed
stewed104814242stewed
stied65723032stied
styed95815482styed
sued56537932s_ued
sueded84014632sueded
taxed135620292taxed
teed55439262te_ed
tewed94718532tewed
unsexed152410252unsexed
vexer155513522vexer
vexes155719122vexes
waxed166018482waxed
weed85637512we_ed

Search took 4 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 Filter178691538000.186960704.3
2DLD Change Limit538001563.50015371.4
3Display Results1561560.0931677.4
 (SQL Overall)1786911563.77947285.3
 
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.