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

214 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
caliche1432996(None) 
caleche14297951caleche
caliches153812271caliches
calicle113111431calicle
cliche133712451c_liche
babiche1644572babiche
cache125122482ca__che
calcine11315272calcine
calcite11413782calcite
caleches15269942caleches
calibre1136602calibre
calices114321692calices
calicles123811432calicles
calico103414432calic_o
calicoes123911602calicoes
calicos113913492calicos
calipee11412912calipee
caliph13311402caliph_
caliphs1436752caliphs
calycle14245832calycle
capuche1644432capuche
caroche1469242caroche
caulicle1245042caulicle
ceviche1744142ceviche
chalice14311042chalic_e
cilice103213352cilic_e
cliched153711022c_liched
cliches144213742c_liches
cloche134312372c_loche
malice104818492malic_e
acalephe1552733acalephe
ache96829823_a__che
affiche1844313affiche
alible8311973_alible
alight103816863_alight
alike95523963_ali_ke
aline57243163_ali_ne
alive85722513_ali_ve
amice96122873_amic_e
apache134210783_apache
babiches1735253babiches
blithe115810863_blithe
caboched1844043caboched
cached145419203ca__ched
caches137926913ca__ches
cachet134526413ca__chet
cacique20205693cacique
caddice13327733caddic_e
caique17318803ca_ique
calash11312433calash_
calashes13310543calashes
calathi1247593calathi
calcar10312753cal_car
calces104420053cal_ces
calcic9311873cal_cic
calcicole1244443calcicole
calcify1735873calcify
calcined1338743calcined
calcines12314753calcines
calcites12313003calcites
calcium1368593calcium
caliber1139733caliber
calibred1335053calibred
calibres1237103calibres
calif104929103cali__f
califate13310483califate
califs114915893cali_fs
calipees1247413calipees
caliper11410963caliper
caliphal1544033caliphal
caliphate1645293caliphate
calix145317353cali__x
callee84327293cal_lee
calliope1256233calliope
callipee1237733callipee
callose9313663callose
calorie92716903calorie
calotte9510563calotte
calque17289843cal_que
calve105919923cal__ve
calycate1537893calycate
calyces14428803calyces
calycine1546963calycine
calycles15295693calycles
calzone1848623calzone
camise103319633cami_se
cancha134411613ca_ncha
canine83826703cani_ne
canticle1239703canticle
caprice1349683capric_e
capuched1843743capuched
capuches1735513capuches
caribe103416753cari_be
carices114220953carices
carinae94318593carinae
cariole9818343cariole
carline93923633carli_ne
carlish12312773carlish_
caroch13911763caroch_
caroches15710693caroches
catch125120373ca_tch_
catcher143115823ca_tcher
catches144320773ca_tches
catchy16559583ca_tchy
catechu1444473catechu
catlike132712933catli_ke
caulicles1344383caulicles
cauline92215613cauli_ne
caviare1238373caviare
cavie104621593cavi__e
cazique27194033cazique
ceviches1834843ceviches
chaliced1637043chaliced
chalices15310813chalices
chichi1637093c_hichi
chicle134312543c_hicle
choice132010523choic_e
ciliate9514603ciliate
cilices113814023cilices
clach124617823c_lach_
clachs133511323c_lachs
claucht1445583claucht
clavicle1543603clavicle
click135217953c_lic_k
clicked164112453c_licked
clicker154111883c_licker
clicks145315113c_licks
clime95720893c_li_me
clinch133910353c_linch_
clinched16347383c_linched
clincher15347663c_lincher
clinches153910373c_linches
cline76428533c_li_ne
clique17289193c_lique
cloches144113713c_loches
clothe114712993c_lothe
colic95726173colic__
colicin11313743colicin
colicine12312993colicine
colicky1835783colicky
colics104219903colic_s
corniche1575923corniche
creche13310763c_reche
cubicle1337003cubicle
culch124512833cul_ch_
culches143710743cul_ches
culices113713123culices
culicid1247383culicid
culicine1248343culicine
cultch13385953cultch_
cultches15316533cultches
curlicue1243223curlicue
cuticle1138233cuticle
cylices14359283cylices
earache1239333earache
fiche134616743__fiche
fleche14299303_fleche
galilee8312213galilee
galoshe1135413galoshe
ganache1346223ganache
gauche1238563ga_uche
halacha15388023halacha
halide103417993hali_de
halite93624233hali_te
kaliph1537873kaliph_
kaliphs1634293kaliphs
laich105920713la_ich_
laichs115110893la_ichs
lalique1644423lalique
lice66045073__lic_e
lich96230853__lich_
lichee114017973__lichee
lichen114012743__lichen
liches114724293__liches
lichi104412953__lichi
licht104723493__licht
lithe84922013__lithe
mache125925303ma__che
malic94525663malic__
malices114316633malices
maline84529103mali_ne
manche133515103ma_nche
mastiche1547173mastiche
miche126219243__miche
niche105016793__niche
palace104516923palac_e
palish114718283palish_
panache1458433panache
panicle11129983panicle
panoche1456383panoche
pastiche1546933pastiche
plaice10311553plaic_e
planche14299763planche
plicae10410953_plicae
police102918563polic_e
potiche1438043potiche
quiche2057903_quiche
radicle103510713radicle
saice75424053sa_ic_e
saithe94713913sa_ithe
salic73424713salic__
salicin9311223salicin
salicine10311703salicine
saline65132713sali_ne
sanicle91210263sanicle
seiche11811833_seiche
seviche1545113seviche
silicle937753silicle
slice74925823_slic_e
splice104915103splic_e
tache106222373ta__che
valine94623103vali_ne
valise92917653vali_se
wavicle1534063wavicle

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 Limit1340272147.01619103.1
3Display Results2142140.0762815.8
 (SQL Overall)1786912147.49823831.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.