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

123 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
ceca8482078(None) 
caca85528081caca
caeca93915131caeca
cecal94619111cecal
coca88030641coca
aceta74017352aceta
aecia73819282aecia
areca75618632areca
becap114315052becap
beck126226572beck
bema85825252bema
beta66234132beta
cacao95420002cacao
cacas95627982cacas
caecal103713732caecal
casa65630862casa
cecum11611842cecum
cedar84014322cedar
cede74928772cede
cedi74919272cedi
cee55952702ce_e
cees65941592cees
ceiba938702ceiba
ceil65725062ceil
cel56040552ce_l
cell65031722cell
cella75420312cella
cels65534972cels
celt65646712celt
cent67451012cent
cep75736332ce_p
cepe84926652cepe
ceps86125952ceps
cercal10314122cercal
cerci93716392cerci
cere66741472cere
ceria75125352ceria
cero66329452cero
cess65326052cess
cesta75419482cesta
cete64934782cete
check164714712check
chela103916802chela
chia96026622chia
chica125818262chica
circa9311402circa
cocas95926572cocas
cock126332902cock
coco87330602coco
cocoa98517882cocoa
coda77029342coda
cola66541392cola
coma87134852coma
coxa136922962coxa
cycad13507272cycad
cycas126513822cycas
cyma116715842cyma
decaf114919442decaf
decal85523232decal
decay114718482decay
deck115827752deck
deco76125972deco
deva85720982deva
ecu56828232_ecu
era35741502_era
eta35834192_eta
fecal105119212fecal
feck134923432feck
feta76528902feta
geck115721992geck
geta56627442geta
heck135826492heck
icecap1245222icecap
kea76540912ke_a
keck94920712keck
lea37660182le_a
lech96825442lech
leva77020712leva
loca65527682loca
mecca1139932mecca
mega77620872mega
mesa67025482mesa
meta65932412meta
mica86428252mica
neck105423662neck
nema65522522nema
oca56731732_oca
orca65522772orca
paca85132242paca
pea56657242pe_a
pec76744412pec_
pecan91919032pecan
pech116125452pech
peck125730682peck
pecs84634102pecs
pica85831492pica
rec55645462rec_
recap95718022recap
reck106130562reck
recs65734182recs
recta74220262recta
scena74815782scena
sea36161292se_a
sec55945322sec_
secs65033892secs
sect67443622sect
sera46141392sera
seta45637312seta
soca66330052soca
tea37353322te_a
tech95925442tech
tecta74215522tecta
tela45532972tela
tepa66021682tepa
theca103311452theca
vela75725542vela
vena76126292vena
vera76828842vera
weka117013872weka
yea66445752ye_a
yech127220532yech
yuca95716722yuca
zeta135121642zeta

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 Filter178691298720.516346300.4
2DLD Change Limit298721231.31322751.0
3Display Results1231230.0304100.0
 (SQL Overall)1786911231.85996122.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.