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

248 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
celiacs1115789(None) 
celiac101910431celiac_
calpacs133110342calpacs
celeriacs1344112celeriacs
celibacy1742642celibacy
cellars93713692cellars
cerias83321982ceria_s
coeliac1138232coeliac_
colics104219902coli_cs
heliac111010892heliac_
relics84517902reli_cs
abelias93213563abelia_s
acedias1039773acedia_s
aerials74017553aerials
alias55834603_alia_s
belays114313853bel_ays
beldams1237053beldams
beleaps1138053beleaps
belgas9311713belga_s
beliefs12448583beliefs
beliers94617383beliers
belies84631053beli_es
beylics1436183beyli_cs
calcars11312653calcars
calices114321693calices
calico103414433cali_co
calicos113913493calicos
califs114915893cali_fs
caliphs1436753caliphs
callans94518473callans
callas84526753calla_s
calpac123211063calpac_
calpack17338333calpack
calpacks18266523calpacks
camelias12510303camelia_s
capias10318353capia_s
cardiacs1376913cardiacs
caviars1238623caviars
cebids11439173cebi_ds
cedars93312833ce_dars
cedis84317083cedi__s
ceibas1038503ce_ibas
ceilers93912533ceilers
ceilidhs1442133ceilidhs
ceilings11397993ceilings
ceilis85413743ce_ilis
ceils75019403ce_i_ls
celebs1037883cel_ebs
celeriac1246163celeriac_
celibacies1643153celibacies
celibate1259313celibate
celibates1358633celibates
cella75420313cella__
cellae84915933cella_e
cellar84514983cella_r
cellists1038563cellists
cellos84517803cel_los
cells75428063cel__ls
celoms10412123cel_oms
celosias1048903celosia_s
cels65534973cel___s
celts75325783cel__ts
centals94317053centals
centas85020703centa_s
cereals9313173cereals
ceria75125353ceria__
ceric94023093ceri_c_
ceriphs1484753ceriphs
cerises94722253cerises
cerites94823433cerites
ceriums1139473ceriums
cesiums1136303cesiums
cestas85018543cesta_s
chelas113817203chel_a_s
chemics16349583chemi_cs
chias104625523c_hia_s
chiaus113611313c_hiaus
chicas135916473c_hicas
chics123920943c_hi_cs
chiliads1445853chiliads
cilia73016763cilia__
ciliary1247923ciliary
ciliate9514603ciliate
ciliates10413453ciliates
cilice103213353cili_ce
cilices113814023cilices
civics13397823civi_cs
clach124617823c_l_ach
clachs133511323c_l_achs
clack134720173c_l_ack
clacks144516343c_l_acks
clads85722733c_l_ads
clags85621123c_l_ags
claims105211573c_laims
clams95127673c_l_ams
clans75031013c_l_ans
claps95626183c_l_aps
class75525483c_l_ass
claws106020833c_l_aws
clays105521333c_l_ays
cleans85817053c_leans
clears84116563c_lears
cleats84919313c_leats
clerics1149333clerics
click135217953c_li_ck
clicks145315113c_licks
cliffs14477593c_liffs
clifts11519153c_lifts
climbs12498723c_limbs
climes104720003c_limes
clinch133910353c_linch
clines84926043c_lines
clings95716213c_lings
clinics11338743c_linics
clinks125815063c_links
clips96018303c_li_ps
clitics11279973c_litics
cloaca1037263c_loaca
cloacas1136233c_loacas
cloaks124411263c_loaks
cobias104014993cobia_s
cognacs1256043cognacs
colas75436773col_a_s
coleads102911423coleads
colic95726173coli_c_
colies84837053coli_es
colins85229043coli_ns
colitis92617353colitis
collars93816573collars
colzas174010513colza_s
comics124015563comi_cs
conics103920593coni_cs
corsacs1139013corsacs
cretics112911653creti_cs
cubics123810163cubi_cs
culices113713123culices
cullays12347703cullays
cylices14359283cylices
cynics13377363cyni_cs
delays104014053del_ays
deleads9379703deleads
delicacy1644253delicacy
delict94320333deli_ct
delicts104012253delicts
delimes10314193delimes
delis64928543deli__s
delists84414173delists
deltas74414823delta_s
denials84114133denials
dezincs1933753dezincs
dulias71212743dulia_s
eclairs935963eclairs
eclats8313033ecl_ats
elains64919853_elains
elans55527753_el_ans
elegiacs1144053elegiacs
elides74420693_elides
elints65816423_elints
elites66027123_elites
epics95014283_epi_cs
ericas8315463_ericas
fecials123510333fecials
felids103111623feli_ds
felines104718073felines
fellahs13428393fellahs
fellas95116963fella_s
ferias95020393feria_s
fetials103711743fetials
flics105418363_fli_cs
galyacs1335273galyacs
gelcaps1235203gelcaps
glias64618493_glia_s
guaiacs1054353guaiacs
heliacal1344723heliacal
heliast10312073heliast
heliasts1136103heliasts
helical12311153helical
helices12313723helices
helios94816633heli_os
helipads1443873helipads
heliums12188303heliums
helixes1739133helixes
iliac75013493_iliac_
iliads7448673_iliads
kalians11310183kalians
kalpacs15327133kalpacs
kelims1278913keli_ms
lacs66942483__l_acs
laics76419253__laics
liars54723163__liars
lilacs837483__lilacs
linacs8310813__linacs
maniacs114313063maniacs
mediacy1536143mediacy
medials103914733medials
medians103214213medians
medias93620783media_s
medics114115353medi_cs
medivacs1644003medivacs
melic94722333meli_c_
menials94015683menials
obelias9279033obelia_s
oomiacs1135683oomiacs
pelican1139433pelican
pelicans1238093pelicans
pelites93821993pelites
pelvics14245643pelvics
pleiads1045223pleiads
redials84416883redials
redias74523603redia_s
relace83122153rel_ace
relaces93420883rel_aces
relays94316753rel_ays
reliance10310473reliance
reliances1139623reliances
reliant7319243reliant
relic74623363reli_c_
relict83623903reli_ct
relicts94414593relicts
reliefs10439433reliefs
reliers75519213reliers
relies65036423reli_es
relines75331323relines
relinks114510223relinks
relists73817053relists
relives104619443relives
reloads8911313reloads
reloans7313133reloans
replicas1237093replicas
scenics1137773sceni_cs
selahs9313213sel_ahs
selvas93812913selva_s
sepias83616103sepia_s
seracs84418573se_racs
serials73919743serials
shellacs1345573shellacs
silicas9310603silicas
telia55821143telia__
telial65815363telia_l
telic76019823teli_c_
tenias64720073tenia_s
theriacs1336543theriacs
triacs83913223_triacs
umiacs1035663_umiacs
velars93913723vel_ars
velites103417303velites
xenias133712973xenia_s
zodiacs1943423zodiacs

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.1561145455.1
2DLD Change Limit1340272487.61017612.0
3Display Results2482480.0932666.7
 (SQL Overall)1786912487.85922737.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.