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

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
aahed91781643(None) 
ached119227831ached
ahed89536251_ahed
ashed97829751ashed
aah616252952aah__
aahs716428552aah_s
abased96514982abased
abashed1357652abashed
abated95918432abated
abed79734122_abed
abled86926802abled
aced79540882_aced
ache96829822ache_
aches106132272aches
acned87520662acned
acred87126352acred
acted88521732acted
added84918412added
adzed166012542adzed
aged67334252_aged
ahead96817032_ahead
ahem97225352_ahem
aided75828922aided
ailed66240282ailed
aimed85626052aimed
aired66032922aired
alated75625122alated
amazed18519292amazed
amped104820512amped
anted66328242anted
aped78538152_aped
aphid115515392aphid
arced88224152arced
arched125717302arched
armed86324432armed
ashen87818652ashen
ashes86230602ashes
asked106919312asked
awaked14579192awaked
awed88436032_awed
awned96615952awned
axed128829612_axed
axled135315812axled
baaed85218162baaed
bached145519882bached
baked126130772baked
baled85436432baled
baned85436352baned
bared85144472bared
based85331572based
bashed126225672bashed
bated85935522bated
bathed125518732bathed
bayed115423022bayed
cached145419192cached
caged95426352caged
caked126128612caked
caned85838092caned
caped104931802caped
cared86050082cared
cased86032412cased
cashed125124332cashed
caved116227552caved
cawed116627062cawed
dared75935012dared
dashed115920542dashed
dated75530982dated
dawed106222812dawed
dazed165919352dazed
eared65139482eared
eased65430392eased
eaved95924492eaved
eched116919212eched
faced117727652faced
faded105025242faded
faked135225482faked
famed115928342famed
fared95842342fared
fashed136720232fashed
fated95632132fated
faxed166220532faxed
fayed126422152fayed
fazed186222962fazed
gaed66031502ga_ed
gaged85522302gaged
gamed95126382gamed
gaped96123522gaped
gashed116321942gashed
gated75329762gated
gazed165520322gazed
haded105227622haded
haed86338582ha_ed
haled95335822haled
hared95742172hared
hashed136021912hashed
hated95734022hated
hawed126025422hawed
hayed125822002hayed
hazed185222192hazed
jaded144417022jaded
japed156217632japed
jawed165517372jawed
laced87132632laced
laded74232602laded
laked105731112laked
lamed85235282lamed
lased65132322lased
lashed105625182lashed
lated65240652lated
lathed104718442lathed
laved95028582laved
lawed96028312lawed
layed95127372layed
lazed154925832lazed
maced108528692maced
maned86634092maned
mashed125325002mashed
mated85537782mated
mawed115824742mawed
maxed155821192maxed
mayed115522402mayed
mazed175523862mazed
naked105320852naked
naled65525052naled
named85223062named
oared65030642oared
ohed87825162_ohed
oohed94214192oohed
paced106931682paced
paged95926772paged
paled85538692paled
paned85437172paned
pared86946742pared
pashed125923102pashed
pated85237842pated
paved115525252paved
pawed115725612pawed
payed115925922payed
raced87635302raced
raged74829442raged
raked105831412raked
raped85334622raped
rared65738312rared
rased65033932rased
rated65441382rated
raved94931422raved
raxed135622662raxed
rayed95127482rayed
razed155027982razed
sabed86526802sabed
saned65636272saned
sashed105622912sashed
sated66238532sated
saved95127102saved
sawed95628402sawed
sayed96127142sayed
shed86536152_shed
tamed85528512tamed
taped85327422taped
tared69340052tared
tawed95926192tawed
taxed135620292taxed
vaned94622422vaned
waded106024742waded
waged104822782waged
waked135626752waked
waled94330992waled
waned95831782waned
wared96339872wared
washed135521482washed
waved125223572waved
waxed166018482waxed
yawed126022452yawed

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 Limit538001731.39338621.7
3Display Results1731730.0463760.9
 (SQL Overall)1786911731.532116639.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2023  |  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.