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

262 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
chalices1531081(None) 
calices114321691c_alices
chalice14311041chalice_
chaliced1637041chaliced
calces104420052c_al_ces
caliches153812272c_aliches
calicles123811432c_alicles
calicoes123911602c_alicoes
calicos113913492c_alicos
calyces14428802c_alyces
carices114220952c_arices
chaines124518732cha_ines
chaises124317492cha_ises
chalcids1635892chalcids
challies133915642challies
challises14358782challises
chalones13312172chalones
chamises153513312chamises
chances145218092cha_nces
charlies133414232charli_es
chilies124218302chili_es
choices142010612ch_oices
cholines132214492cholines
cilices113814022c_ilices
culices113713122c_ulices
cylices14359282c_ylices
halides113416662_halides
halites103221192_halites
helices12313722_helices
malices114316622_malices
alines65735223__alines
amices105018013__amices
apices104916263__apices
avarices1337183avarices
bialies93618413biali_es
caddices14297853caddices
calcines12314753c_alcines
calcites12313003c_alcites
caleches15269943c_aleches
caliber1139733c_aliber
calibers1238523c_alibers
calibres1237103c_alibres
caliche14329963c_aliche
calicle113111433c_alicle
calico103414433c_alic_o
califs114915893c_ali_fs
calipee11412913c_alipee
calipees1247413c_alipees
caliper11410963c_aliper
calipers1249443c_alipers
caliphs1436753c_aliphs
callees94117783c_allees
calques182710193c_alques
calves115119283c_al_ves
calxes154113033c_al_xes
calycles15295693c_alycles
calyxes19426233c_alyxes
camises114218463c_amises
canalises11515493canalises
canalizes201113783canalizes
canines93724033c_anines
capizes20410373c_apizes
caprices1439893caprices
caribes113715643c_aribes
caries85147623c_ari_es
carlines103521653carlines
caudices13337343caudices
caulicles1344383caulicles
cavies114525003c_avi_es
cervices1537133cervices
chablis14368563chabli__s
chafes145017913cha__fes
chaine115119223cha_ine_
chained133812693cha_ined
chains114819703cha_i_ns
chaired134211243cha_ired
chairs114916183cha_i_rs
chais107530313cha_i__s
chaise114916413cha_ise_
chalahs15289883chal_ahs
chalazas2245893chalazas
chalcid1537883chal_cid
chaleh143711993chal__eh
chalehs15268803chal_ehs
chalet113825993chal__et
chalets122813473chal_ets
chalked17449863chal_ked
chalkier1736753chalkier
chalkiest1837093chalkiest
chalks155412143chal__ks
challahs16377563challahs
challas124414123chal_las
challie124012853challie_
challis124613463chal_lis
chalone12312103chalone_
chalupas1554383chalupas
chamades16138653chamades
chamisas15317813chamisas
chamise143612853chamise_
chamisos15307423chamisos
chammies172910163chammies
chamoises16327933chamoises
chance134617093cha_nce_
chanced154113213cha_nced
chancel144011773cha_ncel
chancels15439083cha_ncels
chancer144215633cha_ncer
chancers154313493cha_ncers
chancier1538823chancier
chanciest1638383chanciest
chancres15429363chancres
changes134517583cha_nges
chanties132615803chanties
chaoses124715123cha_oses
chapes135421873cha__pes
chapiter1536603chapiter
chapiters1635203chapiters
chappies172610103chappies
charades141310853charades
charases131312763charases
chares115631803cha__res
charges134615983cha_rges
charier124317903chari_er
chariest13315513chari_est
chariness14310063chariness
chariots1339393chariots
charisms15710263charisms
charities14312743charities
charlie123011923charli_e_
charlocks2044073charlocks
chases115128233cha__ses
chasings14318253chasings
chasses124017503cha_sses
chastises1437703chastises
chausses1345963chausses
chayotes1636503chayotes
cheapies1539033cheapi_es
chedites1438263chedites
chelates132713843chelates
chelicera1642883chelicera
cheliped1635043cheliped
chelipeds1743003chelipeds
chemics16349583chemic_s
chemises153211983chemises
chevies153511443chevi_es
chicas135916473ch__icas
chicer134513603ch__icer
chicest14209943ch__icest
chicks175317593ch__icks
chicles143512503ch__icles
chicos134614833ch__icos
chics123920943ch__ic_s
chides124620473ch__ides
childes134211273chil_des
chiles115425303ch__iles
chiliads1445853chiliads
chilis115517873chili__s
chillies134113483chillies
chimes134922573ch__imes
chines115029173ch__ines
chives144317593ch__ives
chivies153412853chivi_es
choice132010523ch_oice_
choicer14197893ch_oicer
choicest15226453ch_oicest
cholates132414763cholates
choline122915383choline_
chopines152711733chopines
chorines132917253chorines
chyles144813283chyl__es
chymics19295533chymic_s
cilice103213353c_ilice_
cimices13279803c_imices
claries93422203clari_es
clavicles1643673clavicles
cliches144213743c__liches
clicks145315113c__licks
climes104720003c__limes
clines84926043c__lines
coalesces1346043coalesces
coalier93416183coali_er
coaliest10316223coali_est
coalifies1439113coalifies
codices12512583c_odices
colics104219903c_olic_s
colies84837053c_oli_es
collides113214473collides
collies94326583colli_es
complices1739253complices
coolies93824963cooli_es
coppices1638243coppices
cornices12713293cornices
cortices12615013cortices
cowlicks1944663cowlicks
crazies183413853crazi_es
crevices1536713crevices
cullies94419963culli_es
cullises103111313cullises
curlicues1343343curlicues
cutlines102413273cutlines
cyanides14258003cyanides
cyanines132710543cyanines
cyanites132610163cyanites
cyclizes2445523cyclizes
dualizes1838823dualizes
egalites9310503egalites
falces115216003_fal_ces
ghazies2036913ghazi_es
goalies8316023goali_es
hafizes2235983_hafizes
hales85449843_hal__es
halide103417993_halide_
halids104016133_hali_ds
halite93624233_halite_
halitus10339963_halitus
halloes104021523_halloes
halluces1335613_halluces
haloes94623863_hal_oes
halves124717093_hal_ves
hances115621283_ha_nces
haplites1339993_haplites
helixes1739133_helixes
holies94630033_holi_es
hyalines14169333hyalines
hyalites14208833hyalites
italics936993italic_s
khalifas1842513khalifas
khalifs1754073khali_fs
latices9313763_latices
malice104818483_malice_
malines93625603_malines
mealies92821933meali_es
opalines10311423opalines
oxalises1538503oxalises
pachalics1844983pachalic_s
palaces114216463_palaces
plaices11411143pla_ices
polices113118053_polices
pollices12410753pollices
pralines102217723pralines
radices102314263_radices
realises82420183realises
realizes173116843realizes
saices84221803_sa_ices
salines74029413_salines
scolices1238733scolices
shales94731253shal__es
shalier103116423shali_er
shaliest111415063shali_est
shavies134213213shavi_es
slices84022853__slices
spadices1336093spadices
splices113914383_splices
statices102712343statices
talipes9611603_talipes
uralites82112723uralites
valines104520213_valines
valises103516263_valises
varices123313573_varices
walies95324523_wali_es
whales124716943whal__es
whalings15256763whalings

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622626.36022981.4
3Display Results2622620.1062471.7
 (SQL Overall)1786912626.87226002.8
 
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.