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

221 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
cemented133837(None) 
cementer1239191cementer
demented12311271demented
cement103321672cement__
cementa112810542cement_a
cementers1338312cementers
cements112714222cement_s
cementum1444692cementum
commented16129612commented
emended11329602_emended
fermented1546622fermented
fomented1437802fomented
lamented1138192lamented
recemented1546162recemented
relented92614942relented
remelted11310152remelted
remended123010392remended
reminted113615082reminted
repented112614982repented
rerented92516162rerented
resented92716962resented
segmented1345062segmented
absented1156623absented
accented13107803accented
agented939433_agented
alimented1245313alimented
amended11328313_amended
assented957523assented
augmented1343833augmented
bemeaned1335783bemeaned
bemisted1368383bemisted
cadenced1435523cadenced
cameoed1238383came_oed
canted94825783c__anted
caseated11310723caseated
catenated1238923catenated
caveated1439143caveated
cayenned1443163cayenned
celeste949653celeste_
celestes10310013celestes
cementing1438763cementing
cementite13147113cementite
cementites1476183cementites
cementums1543293cementums
cemetery1554923ceme_tery
censed94016323c__ensed
center84421413c__enter
centred103411683c__entred
cerated103922473ce_rated
chanted134015953c_hanted
chaunted1485603chaunted
cheated134416353c_heated
chested133811683c_hested
cleated103417853c_leated
clefted13326763c_lefted
clement11313773clement__
clemently1645063clemently
coempted1535343coem_pted
coerected1447643coerected
coexerted1944763coexerted
combated1539823combated
commenced18157133commenced
commended17137013commended
commenter151410693commenter
commuted15288983commuted
competed154113593competed
compted143813533com_pted
computed154110953computed
consented12311943consented
contented12313043contented
convented15410753convented
counted103815803c_ounted
coveted133011523cove_ted
cozened19349183cozen_ed
created104323463c_reated
cremated133412963crem_ated
crenated113013913c_renated
crested103416553c_rested
cuneated11310103cuneated
curetted1137173curetted
cymene1377393cymen_e_
cymenes1477413cymen_es
decanted122310493decanted
decenter112412163decenter
decentred13236233decentred
defeated132812163defeated
defected15289973defected
defenced1537203defenced
defended1437223defended
defensed1336223defensed
dejected19307593dejected
deleted93314913dele_ted
demanded13348513demanded
demasted1238763demasted
demeaned1237283demeaned
dement93825153dement__
dementedly1743923dementedly
dementia1157833dementia
dements103016623dement_s
demerged13157603demerged
demerited1339073demerited
demitted12288773demitted
demoted114313543dem_oted
demounted1344903demounted
dented84120513__dented
depended1337983depended
deserted101012203deserted
detected12289733detected
detente83313603detente_
detentes92712873detentes
detested10279623detested
devested13239133devested
documented1653203documented
egested938123_egested
ejected17297653_ejected
elected102812613_elected
emanated1139163_emanated
emend86214893_emen__d
emendated1344663_emendated
emender10649843_emender
emerged11158213_emerged
emersed10138513_emersed
emeute838533_emeute_
emeutes938013_emeutes
emitted103010853_emitted
emoted94614923_em_oted
erected103213993_erected
evened101010313_even_ed
everted112711853_everted
exerted152210053_exerted
feinted11379623fe_inted
fermenter1497543fermenter
fomenter1339263fomenter
garmented1345893garmented
geminated1338553geminated
gemmated14336293gemmated
helmeted1435833helme_ted
hented104218753__hented
incented112412553incented
indented101811733indented
invented122510663invented
keened114013633ke_en_ed
lamenter1038863lamenter
levanted1245323levanted
meated94222403__meated
melted94219063__melted
memento11378133mement_o
mementoes13325383mementoes
mementos12267373mementos
mended104418683__mended
mensed93916543__mensed
mentee84121293__mentee
meted85424433__me_ted
minted94220583__minted
omened93711003_omen_ed
oriented937483oriented
parented11912213parented
patented1188893patented
pedimented1644103pedimented
peened94318163pe_en_ed
permeated1439373permeated
pigmented1544063pigmented
precented14310693precented
presented12311633presented
prevented1539003prevented
recanted112513513recanted
recenter102715443recenter
redenied10511283redenied
reenter73217793re_enter
reested82916233re_ested
refected142311663refected
refenced1439003refenced
regimented1444913regimented
reheated122415003reheated
rejected182710113rejected
remanded123011323remanded
remanned11319353remanned
remated103522473rem_ated
remedied1237953remedied
remend95216553remen__d
remerged12149173remerged
reminded123411523reminded
remitted113312073remitted
remounted1236283remounted
renested92212953renested
rented74426593__rented
repeated113117443repeated
repenter102813863repenter
reseated93220263reseated
resected112514743resected
resmelted1236043resmelted
retested92212533retested
retinted94414363retinted
revenged1337553revenged
revenued1237223revenued
reverted122714713reverted
revested122612243revested
revetted122210943revetted
rewetted12228353rewetted
scented102811893_scented
sedimented1444043sedimented
selected1159783selected
semester1038903semester
sklented1335053sklented
smelted10399093_smelted
talented938423talented
telneted935073telneted
tempested1444033tempested
tempted12317283tem_pted
tenanted937043tenanted
tented74221003__tented
tormented1245963tormented
undented102313953undented
unmelted1169183unmelted
unmended12299093unmended
unrented92413923unrented
untented92613413untented
venenated1345903venenated
vented104617923__vented
weened104013733we_en_ed
weeted103913793we_e_ted

Search took 10 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.420425454.8
2DLD Change Limit1461622219.39015565.7
3Display Results2212210.0962302.1
 (SQL Overall)1786912219.90618038.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.