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

180 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
caddice1332773(None) 
caddices14297851caddices
caddie104316451caddi_e
addict10711202_addict
adduce1076452_adduce
advice12107882_advice
baddie104114032baddi_e
caddied123710562caddied
caddies113718382caddies
caddis104613382caddi_s
caddised13315892caddised
caddises12329352caddises
caddish143810122caddish
cadence1239062cadence
cadmic1338982cadmic_
caprice1349682caprice
cardiae10713702cardiae
caudices13337342caudices
cuddie104011172cuddi_e
laddie83713172laddi_e
waddie114013322waddi_e
zaddick2442992zaddick
abduce1197193_abduce
acidic113612133acidic_
addible11236063_addible
addicted1345073_addicted
addicts1176013_addicts
adding93914963_adding
addle74318353_add_le
adduced1274353_adduced
adducer1184163_adducer
adduces1185763_adduces
adduct1087373_adduct
admire949933_admire
advices13136933_advices
advise10139223_advise
aedile73716653_aedile
aedine73218393_aedine
amice96122873_a_mice
asdic83814093_asdic_
asdics9439863_asdics
audile73315303_audile
baddies114017873baddies
bardic11312923bardic_
bodice11711423_bodice
cabbie122913353cabbi_e
caddy125414023cadd__y
caddying16225063caddying
cade76443913ca_d__e
cadelle1039923cadelle
cadenced1435523cadenced
cadences1338473cadences
cadency1545893cadency
cadge94018793ca_d_ge
cadging123610973cadging
cadi75732183ca_di__
cadis84428503ca_di_s
cadmium1446113cadmium
cadre85419023ca_d_re
caducei1243873ca_ducei
calcic9311873calcic_
calcine11315273calcine
calcite11413783calcite
calices114321693ca_lices
caliche14329953ca_liche
calicle113111433ca_licle
calico103414433ca_lico
camise103319633ca_mise
cammie124615293cammi_e
candid104517853candi_d
candida114110253candida
candider1237343candider
candids113812693candids
candied113816023candied
candies104125613candies
candle94321483cand_le
canine83826703ca_nine
cannie83819363canni_e
cantic103920543cantic_
canticle1239703canticle
capric12411803capric_
caprices1439893caprices
caprine11314233caprine
capsize2037623capsize
captive1438973captive
carbide126112493carbide
carbine112918643carbine
cardia9916373cardi_a
cardiac1278813cardiac
cardiacs1376913cardiacs
cardias10715113cardias
carding113922433carding
cardio9915673cardi_o
caribe103416753ca_ribe
carices114220953ca_rices
carline93923613carline
carmine112918483carmine
carnie84421093carni_e
carsick1536343carsick
caseic103212373caseic_
cassine93817283cassine
catface1436763catface
catlike132712933catlike
cattie85221023catti_e
caudate10311353caudate
caudle93912913caud_le
caulicle1245043caulicle
cauline92215603cauline
cavie104621593ca_vi_e
chalice14311043chalice
cheddite1543953cheddite
chedite1338863chedite
choice132010523c_hoice
cilice103213353c_ilice
cladding1337143cladding
coadmire1344043coadmire
codding124014693codding
coddle104713853codd_le
codeine103815033codeine
codices12512583c_odices
codpiece1544063codpiece
codrive1337653codrive
conduce12139233conduce
coppice1537483coppice
cordite10315263cordite
cornice11612933cornice
cowardice1742423cowardice
crevice1436153crevice
cuddies113313263cuddies
cuddle104414533cudd_le
daddies103414943daddies
daddle94214283dadd_le
deice84320033__deice
dice75841893___dice
duddie9348863duddi_e
faddier1237783faddier
faddish15359003faddish
faddism14356723faddism
faddist12289643faddist
fadlike15318483fadlike
gaddi85211633gaddi__
gadding113411453gadding
gaddis94211373gaddi_s
haddock1885583haddock
jadeite1546403jadeite
jaundice1842013jaundice
kaddish16317973kaddish
kiddie12359393kiddi_e
laddies93715053laddies
laddish12299723laddish
lattice938433lattice
lyddite1243333lyddite
madding123711993madding
maddish14289483maddish
malice104818483ma_lice
nardine82712573nardine
paddies113715723paddies
padding123412513padding
paddle104615143padd_le
paddock17104733paddock
pardie96021443pardi_e
pardine103616723pardine
radding103715003radding
raddle84816173radd_le
radicel10278873ra_dicel
radices102314263ra_dices
radicle103510713ra_dicle
readdict1246153readdict
saddle83915493sadd_le
saice75424053sa__ice
sardine83317393sardine
scaldic1235943scaldic_
scandic1237003scandic_
tardive1136893tardive
waddied13358563waddied
waddies124214753waddies
wadding133711943wadding
waddle114715303wadd_le
widdie113410733widdi_e
zaddik2134243zaddi_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 Filter1786911340270.406440125.6
2DLD Change Limit1340271806.64020184.8
3Display Results1801800.0632857.1
 (SQL Overall)1786911807.10925135.9
 
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.