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

272 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
chalice1431104(None) 
chaliced1637041chaliced
chalices15310811chalices
calices114321692c_alices
caliche14329952c_aliche
calicle113111432c_alicle
calico103414432c_alico
chaine115119222cha_ine
chaise114916412cha_ise
chalcid1537882chalcid
challie124012852challie
chalone12312102chalone
chamise143612852chamise
chance134617092cha_nce
charlie123011922charli_e
choice132010522ch_oice
choline122915382choline
cilice103213352c_ilice
halide103417992_halide
halite93624232_halite
malice104818482_malice
alike95523963__alike
aline57243153__aline
alive85722513__alive
amice96122873__amice
anglice1089213anglice
avarice1238033avarice
caddice13327733caddice
calces104420053c_al_ces
calcic9311873c_alcic
calcine11315273c_alcine
calcite11413783c_alcite
caleche14297943c_aleche
caliber1139733c_aliber
calibre1136603c_alibre
caliches153812263c_aliches
calicles123811433c_alicles
calicoes123911593c_alicoes
calicos113913493c_alicos
calif104929103c_ali_f
califs114915893c_alifs
calipee11412913c_alipee
caliper11410963c_aliper
caliph13311403c_aliph
calix145317353c_ali_x
callee84327293c_allee
calque17289843c_alque
calve105919923c_al_ve
calyces14428803c_alyces
calycle14245833c_alycle
camise103319633c_amise
canalise10816213canalise
canalize19914493canalize
canine83826703c_anine
caprice1349683caprice
caribe103416753c_aribe
carices114220953c_arices
carline93923613carline
catlike132712933catlike
caulicle1245043caulicle
cauline92215603cauline
cavie104621593c_avi_e
cephalic1777903cephalic_
chablis14368563chabli_s
chaetae1238603chaetae
chafe135117353cha__fe
chafing163911493chafing
chai95929903cha_i__
chain105723673cha_i_n
chained133812693cha_ined
chaines124518733cha_ines
chains114819703cha_ins
chair105519633cha_i_r
chaired134211243cha_ired
chairs114916183cha_irs
chais107530313cha_i_s
chaises124317493cha_ises
chalah143511663chal_ah
chalahs15289883chalahs
chalaza2145733chalaza
chalazae2244423chalazae
chalcids1635893chalcids
chaleh143711993chal_eh
chalehs15268803chalehs
chalet113825993chal_et
chalets122813473chalets
chalk144814603chal__k
chalked17449863chalked
chalkier1736753chalkier
chalking183310063chalking
chalks155412143chal_ks
chalky18468773chal_ky
challa114014193chal_la
challah15458323challah
challas124414123challas
challies133915643challies
challis124613463challis
challises14358783challises
challot123613263challot
chally144314293chal_ly
chalones13312173chalones
chalot113020133chal_ot
chaloth15298603chaloth
chalupa1444473chalupa
chalutz2195093chalutz
chamade15138453chamade
chamisa14328853chamisa
chamises153513313chamises
chamiso14348653chamiso
chanced154113213cha_nced
chancel144011773cha_ncel
chancer144215633cha_ncer
chances145218093cha_nces
chancier1538823chancier
chancre14348783chancre
chancy164010863cha_ncy
change124116753cha_nge
chaotic14310043chaotic_
chape125221143cha__pe
chapiter1536603chapiter
chappie16298653chappie
charade13129913charade
chare105231983cha__re
charge125114213cha_rge
charier124317903charier
charily15310283charily
charing133721323charing
chariot12316213chariot
charism14712203charism
charity15311023charity
charlies133414233charlies
charlock1944393charlock
chase105127123cha__se
chasing133715893chasing
chasmic16177983chasmic_
chasse115114603cha_sse
chaste114617393cha_ste
chastise1348173chastise
chawing164813033chawing
chayote1536493chayote
cheapie1437563cheapi_e
chedite1338863chedite
chelae113614603chel_ae
chelate122914893chelate
chelicera1642883chelicera
cheliped1635043cheliped
chemic153012093chemic_
chemics16349583chemics
chemise143211503chemise
chic115925203ch__ic_
chica125818263ch__ica
chicer134513603ch__icer
chick165419133ch__ick
chicle134312543ch__icle
chico124218253ch__ico
chics123920943ch__ics
chide115321013ch__ide
childe124711213chil_de
chile105626893ch__ile
chili106218483chili__
chiliad1337563chiliad
chilies124218303chilies
chilis115517873chili_s
chime125322593ch__ime
chine105231723ch__ine
chive135117623ch__ive
choicer14197893ch_oicer
choices142010613ch_oices
cholate122114933cholate
cholines132214493cholines
chopine143512263chopine
choric133515903choric_
chorine123218363chorine
chyle134913483chyl__e
chymic18317883chymic_
chymics19295533chymics
cilices113814023c_ilices
clamlike1635163clamlike
clavicle1543603clavicle
clawlike1733913clawlike
claylike1734463claylike
cliche133712453c__liche
click135217953c__lick
clime95720893c__lime
cline76428533c__line
coalesce1245423coalesce
coalier93416183coalier
coalify1536683coalify
coaling103722823coaling
colic95726173c_olic_
colics104219903c_olics
collide103214793collide
collie83621993colli_e
complice1639333complice
coolie83821603cooli_e
coppice1537483coppice
cornice11612933cornice
cowlick1835263cowlick
crablike1636023crablike
crevice1436153crevice
culices113713123c_ulices
cuplike1537213cuplike
curlicue1243223curlicue
cutline92914543cutline
cyanic133110773cyanic_
cyanide13298843cyanide
cyanine122911513cyanine
cyanite122710763cyanite
cyclic1238033cyclic_
cyclize2345403cyclize
cylices14359283c_ylices
dualize1759763dualize
egalite8311563egalite
goalie7413163goali_e
habile11515213_habile
hale76052833_hal__e
halid94424983_hali_d
halides113416663_halides
halids104016133_halids
haling104229783_haling
halites103221193_halites
halve114818923_hal_ve
hance105424153_ha_nce
haplite12310703_haplite
hatlike143311713_hatlike
helices12313723_helices
hyaline132310723hyaline
hyalite13229473hyalite
italic839903italic_
italics936993italics
khalif1657833khali_f
khalifa1742883khalifa
khalifs1754073khalifs
lice66045063___lice
malic94525663_malic_
malices114316623_malices
maline84529083_maline
mealie82519813meali_e
opaline9412483opaline
oxalic1537093oxalic_
pachalic1757273pachalic_
pachalics1844983pachalics
palace104516913_palace
pealike131211273pealike
phallic1447293phallic_
phasic133612053phasic_
phatic133014413phatic_
phylic16279553phylic_
plaice10311553pla_ice
police102918563_police
praline93019743praline
realise73021813realise
realize162717083realize
saice75424053_sa_ice
salic73424713_salic_
saline65132703_saline
shale85332833shal__e
shalier103116423shalier
shavie124312423shavi_e
sialic8313633sialic_
slice74925823__slice
splice104915103_splice
statice92614033statice
tealike111111083tealike
thallic1246553thallic_
thrice114311573th_rice
unalike11311533unalike
uralite71714103uralite
valine94623093_valine
valise92917643_valise
whale115517433whal__e
whaling143910773whaling

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 Limit1340272725.90622693.4
3Display Results2722720.1102472.7
 (SQL Overall)1786912726.40627894.3
 
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.