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

147 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
ailments103943(None) 
ailment9314231ailment_
aliments10311091aliments
bailments1346461bailments
abluents1045462abluents
aliment9316702aliment_
aments85219802a__ments
augments1137832augments
bailment1249182bailment_
diluents946052diluents
figments1446942figments
filaments1446652filaments
fitments1376792fitments
pigments1337342pigments
raiments1039902rai_ments
silents73514492sil_ents
abetments1346073abetments
abluent939623abluent_
absents93510723a_bsents
abutments1345283abutments
accents113511233a_ccents
acumens1136953acumen_s
adamants1186343adamants
advents11309473a_dvents
affixments2543073affixments
affluents15133303affluents
agents74816293a__gents
aglets73915683agl_e_ts
aidmen92610373aidmen__
aiglets84012913aigle_ts
aigrets82810533aigre_ts
aimers84621913ai_me_rs
aimless93610813aimle_ss
airmen82612353airmen__
alants67722023a_l_ants
alerts64418223a_l_erts
aliens65619213a_lien_s
alignments1344633alignments
alimental1155863alimental
alimented1245313alimented
alinements1247133alinements
alkenes114212753a_lkenes
allotments1244463allotments
almehs11619493a_lme_hs
almes75126543a_lme__s
almners9399563a_lmners
almonds10127953a_lmonds
ambients1246053ambients
amends94713283a__mends
amens75624843a__men_s
ament76036543a__ment_
ancients1098973ancients
annulments1244653annulments
aplenty1237173apl_enty
argents84014853a_rgents
arguments1256573arguments
armaments1347473armaments
armets84918353a_rme_ts
armlets94610063armle_ts
arpents93613083a_rpents
ascents93812553a_scents
assents74512223a_ssents
assoilments1353613assoilments
audients946353audients
augment10910203augment_
averments1449093averments
basements1348263basements
billets94516153bille_ts
casements1348583casements
cements112714223_cements
clients938093_clients
comments142913883comments
dements103016623_dements
derailments1446103derailments
devilments1646383devilments
diluent8310263diluent_
dissents93411863dissents
dolmens10388693dolmen_s
easements11410333easements
elements10312173elements
eluents738703_eluents
entailments1346353entailments
ferments13311473ferments
figment1379743figment_
filament13410033filament_
filberts1334993filberts
filets94718953fil_e_ts
fillets103414753fille_ts
filmers124211293filme_rs
filmsets1353413filmsets
fitment12710303fitment_
foments122912053_foments
garments1139963garments
gilberts1134183gilberts
gillnets934733gillnets
gimlets10338433gimle_ts
habiliments1852553habiliments
helmets12309073helme_ts
hutments1345603hutments
ilmenite1046223_ilmenite
ilmenites1146103_ilmenites
incents92414533_incents
indents83114663_indents
intents72115703_intents
invents102812053_invents
kismets13306883kisme_ts
laments94314853_laments
ligaments1246203ligaments
limens84618033li_men_s
liniments1146613liniments
loments93413473_loments
mailmen1137273mailmen__
mildens10339933milden_s
millets94216843mille_ts
mismeets12297733mismeets
moments113113123_moments
nailsets834553nailse_ts
oddments1244103oddments
oilmen848313oilmen__
ointments1166653ointments
paraments13511553paraments
pavements1647003pavements
payments1536943payments
pelmets11309693pelme_ts
pigment12510733pigment_
pimento1157223pi_mento
pimentos1246233pi_mentos
raiment9315413rai_ment_
ravelments1545193ravelments
relents74018503rel_ents
rillets74216153rille_ts
salients839563salients
sarments10311963sarments
segments1138903segments
shipments16254703shipments
siemens938413siemen_s
silent64125843sil_ent_
silenus7369693sil_enus
sklents11348163skl_ents
solvents1136763solvents
splents93912133spl_ents
talents7312013tal_ents
torments10310453torments
varments1339063varments
weldments1544423weldments
willets104414323wille_ts
wisents10249063wi_sents

Search took 9 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.440406115.9
2DLD Change Limit1461621477.84318636.0
3Display Results1471470.0463195.7
 (SQL Overall)1786911478.32921454.1
 
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.