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

258 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
clerics114933(None) 
cleric10612131cleric_
clerids1049091clerids
calorics122810462calorics
celeriacs1344112celeriacs
celeries10316312celeries
cercis104614492c_ercis
cerias83321982c_erias
ceric94023092c_eric_
chemics16349582chemics
claries93422202claries
clergies1137902clergies
clerical1248232clerical
clericals1345352clericals
clerid9312412cleri_d
clerisy1246822clerisy
clerks12458842cler_ks
clevis1158962clevi_s
clinics11338742clinics
clitics11279972clitics
cretics112911652cretics
fluerics1345392fluerics
icterics1247052icterics
lyrics11357942_lyrics
sferics1236132sferics
aeries64737783_aeries
agarics10319943agarics
alcaics1137023alcaics
aldrins8310203aldrins
alecs76620733ale__cs
alembics1442963alembics
alerts64418223aler_ts
alevins102110573alevins
alexias14249793alexias
alexins141910663alexins
aperies9423203aperies
baldrics13164893baldrics
caloric113413223caloric_
calories102919563calories
cambrics1645253cambrics
capric12411803capric_
caprice1349683caprice
caprices1439893caprices
capris10415083capri_s
carices114220953c_arices
caries85147623c_aries
carries94328013carries
cebids11439173c_ebids
cedis84317083c_edi_s
ceils75019403c_e_ils
celeriac1246163celeriac
celerity1347643celerity
celiacs11157893celiacs
ceramics1446803c_eramics
cerci93716393c_er_ci
cercus105013153c_ercus
ceres75540013c_er_es
cereus85215523c_ereus
ceria75125353c_eri_a
cering94522533c_ering
ceriph1398463c_eriph
ceriphs1484753c_eriphs
cerise84822043c_erise
cerises94722253c_erises
cerite84724873c_erite
cerites94823433c_erites
cerium10313763c_erium
ceriums1139473c_eriums
ceros74726073c_er_os
cerous85821203c_erous
certes84623083c_ertes
cervices1537133c_ervices
chebecs1635013chebecs
cheerios13317583cheerios
chemic153012093chemic_
cherish15310463cherish
cherries131812983cherries
cherts115617233cher_ts
cherubs1434553cherubs
chervils1644553chervils
chevies153511443chevies
chics123920943c__hics
chloric143410613chloric_
chlorids14299673chlorids
chlorins132612883chlorins
choleric15107913choleric_
choric133515903choric_
chymics19295533chymics
cinerins10414103cinerins
citric102812313citric_
citrins92614363citrins
civics13397823c_ivics
claims105211573cl_aims
clarets94111103clarets
clarify1536093clarify
clarion9311663clarion
clarions10310493clarions
clarity12310913clarity
clarkias1444793clarkias
claroes93113733claroes
claros84015113clar_os
classics12418873classics
clastics122811413clastics
cleans85817053cle_ans
clearers10349303clearers
clearing113014883clearing
clearings12286063clearings
clears84116563cle_ars
cleats84919313cle_ats
cleaves124111623cleaves
cleeks125010543cle_eks
clefs106616243cle__fs
clefts114610163cle_fts
clench133910053cle_nch
cleomes1138813cleomes
clepes104214623cle_pes
cleping123310423cleping
clergy1234993cler_gy
clerihew1642683clerihew
clerihews1741553clerihews
clerisies1147253clerisies
clerk115812453cler__k
clerked14326653clerked
clerking15257163clerking
clerkish1744263clerkish
clerkly1643573clerkly
clevises1336903clevises
clewing13359583clewing
clews105516333cle__ws
click135217953cl__ick
clicks145315113cl__icks
clinic104312793clinic_
clips96018303cl__ips
clitic103315053clitic_
clivias1266693clivias
clonic104914673clonic_
coedits10310243coedits
coerce10310403coer_ce
coerces11311943coerces
coerect11913353coerect
coerects1258543coerects
colics104219903c_olics
colonics123711613colonics
comics124015563c_omics
conics103920593c_onics
corries94026803corries
coteries10422703coteries
cowries124218013cowries
credits1039973credits
cretic102816283cretic_
cretins93216423cretins
crevice1436153crevice
crevices1536713crevices
cribs94516753c__ribs
crick135118753c__rick
cricks144316053c__ricks
cries75438403c__ries
cris66233433c__ri_s
critics112811093critics
crits75527573c__rits
crocs95722433c__rocs
cubics123810163c_ubics
culprits1245583culprits
culverins1445373culverins
cupric1249123cupric_
curies84934023c_uries
curios83218333c_urios
curries93723163curries
cutleries1179213cutleries
cycleries1647033cycleries
cyesis1148573cyesi_s
cynics13377363c_ynics
darics94314113_darics
eclectics1254813eclectics
eldrich1354583eldrich
electrics1348003electrics
elegiacs1144053elegiacs
elegies81312903elegies
elegits8149343elegits
elemis8312383elemi_s
emeries91620023emeries
emetics11610723emetics
enterics10312853enterics
epics95014283__epics
erica7316543__erica
ericas8315463__ericas
fabrics1436093fabrics
faeries104118993faeries
ferias95020393_ferias
flics105418363fl__ics
florins10311643florins
flueric1246143flueric_
generics11118793generics
glorias81610323glorias
glories81915923glories
herdics13249523_herdics
heroics122912003_heroics
icteric1138023icteric_
irenics937833irenics
jerids142810943_jerids
laics76419253_l_aics
laris54737463_lari_s
legits71313003_legits
leis45739603_le_i_s
lenis56326863_leni_s
levies93919863_levies
levins94514653_levins
levis85818553_levi_s
lewis85315843_lewi_s
lexica1536103_lexica
lexis125916033_lexi_s
logics95711123_logics
lorica8310443_lorica
lories64933043_lories
loris55329153_lori_s
luetics937323luetics
lyric104512723_lyric_
medics114115353_medics
mercs96020453_mer_cs
merits8320873_merits
metrics11312363metrics
numerics1266283numerics
olefins1037493olefins
oleic7313333ole_ic_
oleins6313523ole_ins
peeries93623023peeries
pelvics14245643pelvics
perils84121853_perils
peris75537073_peri_s
poetics11312073poetics
polemics1448183polemics
pterins9812993pterins
queries16315873queries
relics84517903_relics
rerigs74014793_rerigs
rubrics1177093rubrics
scenics1137773scenics
scleras948223scler_as
sclereids1243853sclereids
sclerite10410713sclerite
sclerites1139443sclerites
scleritis1146413scleritis
sclerotics1443973sclerotics
sclerous1047923sclerous
seracs84418573_seracs
series64540973_series
serifs94017053_serifs
serins64029673_serins
sherifs13299683sherifs
spherics1537073spherics
steric8317063steric_
theriacs1336543theriacs
torics85118353_torics
valeric1238303valeric_
veeries102916893veeries
vitrics12198553vitrics
voleries11313233voleries
xeric144315663_xeric_

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.403443402.0
2DLD Change Limit1340272586.42320866.7
3Display Results2582580.0932774.2
 (SQL Overall)1786912586.91925826.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.