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

153 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
ached11922783(None) 
aahed917816441aahed
aced79540881ac_ed
ache96829821ache_
aches106132291aches
acned87520661acned
acred87126351acred
acted88521731acted
ahed89536251a_hed
arched125717321arched
ashed97829771ashed
bached145519891bached
cached145419201cached
eched116919221eched
abed79734132a_bed
abled86926832abled
accede1138292accede
ace59656832ac_e_
aces67645092ac_es
achene11313812achene
achier113914262achier
achoo10315082achoo
achy126316092ach_y
acid77533392ac_id
ackee115825362ackee
acme86924322acme_
acmes96020652acmes
acne66625872acne_
acnes75922622acnes
acold86214922acold
acre67330772acre_
acres76327762acres
acrid86920102acrid
added84918432added
adzed166012542adzed
aged67334252a_ged
ahead96817052a_head
ahem97225362a_hem
aided75828932aided
ailed66240282ailed
aimed85626052aimed
aired66032922aired
amped104820512amped
anted66328242anted
aped78538152a_ped
aphid115515392aphid
arced88224162arced
archer115016242archer
arches114822042arches
arcked136211942arcked
armed86324432armed
ashen87818672ashen
ashes86230612ashes
asked106919312asked
awed88436032a_wed
awned96615952awned
axed128829612a_xed
axled135315812axled
baches135426942baches
backed155725722backed
bashed126225702bashed
batched154114242batched
bathed125518742bathed
beached154516552beached
cache125122482cache_
caches137926912caches
cachet134526412cachet
caged95426362caged
caked126128622caked
caned85838092caned
caped104931802caped
cared86050092cared
cased86032412cased
cashed125124352cashed
caved116227562caved
cawed116627062cawed
chad105525502_chad
chef125125622_chef
chew126622132_chew
chez184519022_chez
chid106626402_chid
coached153313842coached
coed77140542_coed
cred76530882_cred
cued76329562_cued
dashed115920562dashed
eche97520282eche_
eches106322162eches
echoed125211152echoed
etched123613702etched
faced117727652fac_ed
fashed136720252fashed
gashed116321972gashed
hacked164923512hacked
hashed136021942hashed
hatched163414462hatched
iced78721892ic_ed
inched124514482inched
itched123812022itched
jacked204817522jacked
laced87132642lac_ed
laches116528342laches
lacked135324652lacked
lashed105625212lashed
latched133914062latched
lathed104718452lathed
leached133715042leached
leched123716002leched
maced108528692mac_ed
mache125925302mache_
maches134827232maches
macled116718112macled
marched153813402marched
mashed125325042mashed
matched153513962matched
miched143913392miched
naches114622412naches
nacred95212492nacred
niched125514062niched
ocher104516102ocher
ochred12328002ochred
ohed87825182_ohed
oohed94214212oohed
ouched124316932ouched
paced106931682pac_ed
packed154822602packed
parched154013692parched
pashed125923142pashed
patched153514622patched
peached154315882peached
peched144915342peched
poached154212402poached
raced87635312rac_ed
rachet115028972rachet
racked134526082racked
ranched133113602ranched
reached134619082reached
roached133211832roached
ruched124314632ruched
sachem134012222sachem
sachet114725772sachet
sacked135525212sacked
sacred94917102sacred
sashed105622942sashed
shed86536152_shed
tache106222372tache_
taches114224172taches
tacked134723942tacked
teched124014432teched
washed135521502washed
watched163012822watched
yachted1634852yachted
yacked164516792yacked

Search took 2 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.0931921408.6
2DLD Change Limit538001531.57634137.1
3Display Results1531530.0463326.1
 (SQL Overall)1786911531.715104193.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.