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

192 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
caddices1429785(None) 
caddice13327731caddice_
caddies113718381caddi_es
caddises12329351caddises
caudices13337341caudices
addicts1176012_addicts
adduces1185762_adduces
advices13136932_advices
baddies114017872baddi_es
caddie104316452caddi_e_
caddied123710562caddi_ed
caddis104613382caddi__s
caddised13315892caddised
cadences1338472cadences
calices114321692ca_lices
candies104125612candi_es
caprices1439892caprices
carices114220952ca_rices
codices12512582c_odices
cuddies113313262cuddi_es
daddies103414942daddi_es
laddies93715052laddi_es
paddies113715722paddi_es
radices102314262ra_dices
waddies124214752waddi_es
abduces1286243_abduces
addaxes1634573_addaxes
addict10711203_addic_t
addicted1345073_addicted
addles84216603_add_les
adduce1076453_adduce_
adduced1274353_adduced
adducer1184163_adducer
adducers1283443_adducers
adducts1174603_adducts
admires1038663_admires
admixes1765963_admixes
advice12107883_advice_
advises11138973_advises
aediles83413903_aediles
amices105018013_a_mices
apices104916263_a_pices
asdics9439863_asdic_s
audiles83112613_audiles
baddie104114033baddi_e_
baldies105317703baldi_es
bandies104124863bandi_es
bawdies134613393bawdi_es
biddies113514493biddi_es
bodices12710593_bodices
buddies113914353buddi_es
cabbies133115163cabbi_es
caddish143810123caddi_sh
cadelles1139973cadelles
cadence1239063cadence_
cadenced1435523cadenced
cadencies1447323cadencies
cades85440733ca_d__es
cadges104716703ca_d_ges
cadis84428503ca_di__s
cadmic1338983cadmic__
cadmiums1544403cadmiums
cadres94017933ca_d_res
caducei1243873ca_ducei
caduceus1342573ca_duceus
calces104420053ca__lces
calcines12314753calcines
calcites12313003calcites
caliches153812263ca_liches
calicles123811433ca_licles
calicoes123911593ca_licoes
calicos113913493ca_licos
calyces14428803ca_lyces
camises114218463ca_mises
cammies134016483cammi_es
candidas12338643candidas
candider1237343candider
candidest1346533candidest
candids113812693candi_ds
candied113816023candi_ed
candles104422343cand_les
canines93724033ca_nines
canticles1339183canticles
capizes20410373ca_pizes
caprice1349683caprice_
capsizes2147203capsizes
captives1538623captives
carbides133111693carbides
carbines123617533carbines
cardiacs1376913cardiacs
cardiae10713703cardiae_
cardias10715113cardi_as
cardings123812633cardings
carditis11310223carditis
caribes113715643ca_ribes
caries85147623ca_ri_es
carlines103521643carlines
carmines123617863carmines
carnies94123963carni_es
carries94328013carri_es
cassines103116613cassines
cassises103811743cassises
catfaces1536963catfaces
catties94023053catti_es
caudates11310263caudates
caudexes1843843caudexes
caudles103912813caud_les
caulicles1344383caulicles
cavies114525003ca_vi_es
cervices1537133cervices
chalices15310813chalices
cheddites1643013cheddites
chedites1438263chedites
choices142010613c_hoices
cilices113814023c_ilices
cimices13279803c_imices
claddings1433213claddings
coadmires1444033coadmires
coddles114213593codd_les
codeines113114523codeines
codpieces1643803codpieces
codrives1437663codrives
conduces13129783conduces
coppices1638243coppices
cordites11314623cordites
cornices12713293cornices
cortices12615013cortices
cowardices1842373cowardices
crevices1536713crevices
crudites1137763crudites
cuddie104011173cuddi_e_
cuddles114014093cudd_les
culices113713123c_ulices
cylices14359283c_ylices
daddles104213803dadd_les
dandies94121443dandi_es
deices94119373__deices
dices86434243___dices
eddies83313163_eddi_es
faddier1237783faddi_er
faddiest1338113faddi_est
faddisms15264983faddisms
faddists13235543faddists
fuddies123211203fuddi_es
gaddis94211373gaddi__s
gaudies9311973gaudi_es
giddies103713363giddi_es
haddocks1984903haddocks
hardies114923233hardi_es
indices103513443_indices
jadeites1645823jadeites
jaundices1942183jaundices
kaddishes1844093kaddishes
kiddies133412283kiddi_es
laddie83713173laddi_e_
ladies75124883la_di_es
latices9313763la_tices
lattices1038383lattices
lyddites1342583lyddites
malices114316623ma_lices
matrices12312083matrices
middies113116153middi_es
muddies113513953muddi_es
neddies92710703neddi_es
noddies93512043noddi_es
paddings13297013paddings
paddles113515643padd_les
paddocks1894323paddocks
pandies104224503pandi_es
raddles93615703radd_les
radicel10278873ra_dicel
radicels11297183ra_dicels
radicles11249703ra_dicles
radixes15259343ra_dixes
randies84225663randi_es
readdicts1343613readdicts
saddles95415743sadd_les
saices84221803sa__ices
sardines92815563sardines
soddies92312853soddi_es
spadices1336093spadices
tardies84225863tardi_es
teddies92711283teddi_es
toddies93011993toddi_es
varices123313573va_rices
waddie114013323waddi_e_
waddied13358563waddi_ed
waddings14356473waddings
waddles124314843wadd_les
wadies105121203wa_di_es
widdies123514033widdi_es
zaddick2442993zaddic_k

Search took 8 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.1701051123.5
2DLD Change Limit1461621926.84621350.0
3Display Results1921920.0762526.3
 (SQL Overall)1786911927.09225196.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.