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

207 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
clement1131377(None) 
cement103321661c_ement
element9317801element
aliment9316702aliment
casement12311952casement
cementa112810532c_ementa
cements112714222c_ements
cerement12315132cerement
clamant11312432clamant
clemency1743692clemency
clemently1645062clemently
client8316342cl_ient
comment1310317702comment
credent10313972credent
dement93825142_dement
elements10312172elements
inclement1349922inclement
lament85024942_lament
loment84021472_loment
abetment1248233abetment
ailment9314233ailment
aliments10311093aliments
alinement1149103alinement
ament76036543__ament
augment10910203augment
averment13311603averment
axemen1547493axemen_
basement12311493basement
blent76230953bl__ent
bodement13410123bodement
cabmen123610653cabmen_
cadent94120363c_adent
cajolement2155233cajolement
calamint12315133calamint
calescent13118223calescent
calmest11312343calmest
calumet11313293calume_t
candent10417363candent
carmen104019343carmen_
casements1348583casements
catmint11314463catmint
cavemen1437143cavemen_
cemented1338373c_emented
cementer1239193c_ementer
cementum1444693c_ementum
cent67451013c___ent
cerements13411453cerements
cermet10321153cerme_t
chemist143615003chemist
cholent12313253cholent
claimant1247483claimant
claret84026573clare_t
clean75420413cle_an_
cleaned103512003cleaned
cleaner93712303cleaner
cleanest10310293cleanest
cleans85817053cle_ans
clearest1038653clearest
cleat76335063cl__eat
cleek115514913cle_e_k
cleeks125010543cle_eks
cleft106222853cl__eft
cleome1039083cleome__
cleomes1138813cleome_s
clepe94617383clepe__
cleped115114113clepe_d
clepes104214623clepe_s
cleping123310423cleping
clept95725773cl__ept
cleveite1343823cleveite
clever114611533cleve_r
clewed1225113203clewe_d
clewing13359583clewing
clients938093cl_ients
clime95720893clime__
climes104720003clime_s
closest94312533closest
closet85226603close_t
cloven114211513cloven_
clubmen1334253clubmen_
coagent10313983coagent
coempt12311033coem_pt
coerect11913353coerect
coexert16312363coexert
cogent9321003c_ogent
coherent13412473coherent
comet95946073c_ome_t
commend144010183commend
comments142913883comments
complement18510103complement
concent114422513concent
consent93723113consent
content94326153content
convent123919413convent
couplement1647413couplement
cowmen13810923cowmen_
creme94319323creme__
cremes104517993creme_s
cremini11229063cremini
crescent12711053crescent
crewmen1436383crewmen_
current9313693current
cymene1377393c_ymene
decent94023703_decent
decrement14411053decrement
dements103016623_dements
detent73624483_detent
easement10414163easement
elegant8311503elegant
elemental1145883elemental
eleven988303eleven_
elevens1066803elevens
eleventh1443773eleventh
elopement13118223elopement
eluent6315483el_uent
emend86214893__emend
event85924443__event
excrement2048063excrement
ferment12315573ferment
figment1379743figment
filament13410033filament
fitment12710303fitment
flamen115215993flamen_
flamens124611063flamens
fleet85932333fle_e_t
flehmen1534913flehmen_
flehmens1643233flehmens
fleshment1745503fleshment
fluent9313933fl_uent
flymen14387773flymen_
foemen11310523foemen_
foment113718303_foment
garment10315233garment
gerent73223093_gerent
gleemen1035723gleemen_
gleet65532343gle_e_t
helmet113718933helme_t
hutment1239173hutment
icemen1037893icemen_
implement1549533implement
increment13411683increment
lambent113711303_lambent
laments94314853_laments
lamest84722763_lamest
latent64124303_latent
leant56737783_le_ant
learnt64019253_learnt
leben7314853_leben_
lebens8310093_lebens
leet45957903_le_e_t
legend837693_legend
legmen939343_legmen_
leman75622603_leman_
lemans85316393_lemans
lemon75618183_lemon_
lemons84415053_lemons
lemony11419553_lemony
lenient7313843_lenient
lent46360533_l__ent
levant9314493_levant
limen75426033_limen_
limens84618033_limens
lomenta92710133_lomenta
loments93413473_loments
lucent8313823_lucent
lumen75220903_lumen_
lumens85013973_lumens
memento11378133_memento
moment103319683_moment
movement1549433movement
oddment1145923oddment
pavement1549443pavement
payment14310703payment
pelmet103419243pelme_t
pigment12510733pigment
placement1548183placement
precent113520263precent
premeet11615153premeet
premen105017803premen_
present94022733present
prevent124016553prevent
raiment9315413raiment
recement12315653recement
recent83630853_recent
recrement13411363recrement
regent74127673_regent
relent64431853_relent
remeet86325473_remeet
remelt85123123_remelt
remend95216553_remend
remet74843723_reme_t
remint85329973_remint
repent84728873_repent
rerent63832453_rerent
resent63833623_resent
sarment9318763sarment
segment10312563segment
semen75724103_semen_
semens84616963_semens
siemens938413siemens
sleet55639133sle_e_t
telemen9310173telemen_
tenement10412593tenement
torment9316173torment
varment12313243varment
vehement1647763vehement
weldment1445823weldment

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.390458182.1
2DLD Change Limit1340272075.81323056.4
3Display Results2072070.0762723.7
 (SQL Overall)1786912076.27928458.5
 
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.