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

329 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
cretics11291165(None) 
cretic102816281cretic_
cretins93216421cretins
critics112811091critics
arctics1138952arctics
chemics16349582chemics
clerics1149332clerics
clitics11279972clitics
creatins103617512creatins
credits1039972credits
cretin82917912creti_n
crevice1436152crevice
crevices1536712crevices
critic103616812critic_
emetics11610722emetics
erotics91914152erotics
heretics13310502heretics
irenics937832irenics
luetics937322luetics
paretics122312442paretics
poetics11312072poetics
relics84517902_relics
reties65436192_reties
uretic82914352uretic_
acetic10314503acetic_
acetins9313173acetins
acrostics1346983acrostics
acrotic112515543acrotic_
acrylics1584363acrylics
anoretics1148643anoretics
antics84621453_antics
arctic10313513arctic_
areic73219393are_ic_
aretes64425353aret_es
arsenics1056763arsenics
ascetics1247073ascetics
atretic9313923atretic_
attics84413283_attics
auxetics1744763auxetics
biotics113812173biotics
brewis11469983brewi_s
bustics11810883bustics
cantic103920543cantic_
carets85330773caret__s
carotids11229943carotids
carotins102315583carotins
catties94023053catties
caustics1237483caustics
cebids11439173c_ebids
cedis84317083c_edi_s
ceils75019403c_e_ils
celiacs11157893c_eliacs
ceramics1446803ceramics
ceratins102818733ceratins
cercis104614493cerci_s
cerias83321983c_erias
ceric94023093c_eric_
cerites94823433cerites
cerotic11415063cerotic_
certes84623083cert_es
certify1546243certify
cervices1537133cervices
cetes75731103c_et_es
chebecs1635013chebecs
chemic153012093chemic_
chetahs15347073chetahs
cheths14389823chet_hs
chevies153511443chevies
chics123920943c__hics
chitins122713793chitins
chronics1538683chronics
chymics19295533chymics
cities84524853c_ities
civics13397823c_ivics
clastics122811413clastics
cleric10612133cleric_
clerids1049093clerids
clevis1158963clevi_s
clinics11338743clinics
clitic103315053clitic_
coatis85122603coati_s
coedits10310243coedits
colics104219903c_olics
cometic131215723cometic_
comics124015563c_omics
conics103920593c_onics
cooties93725733cooties
cortices12615013cortices
cortins92421333cortins
cosmetics1545463cosmetics
crasis85020473crasi_s
cratch134110793crat_ch
craters95021893craters
crates85736063crat_es
crating103725203crating
cratons94316033cratons
crazies183413853crazies
creaks124315963cre_aks
creams104715253cre_ams
creases94020963creases
creates95225203creates
creatin93618133creati_n
creatine103417413creatine
creatines112814433creatines
creating113921953creating
creation102816513creation
creations112614543creations
creative132812803creative
creatives14279693creatives
creators102814413creators
creches14313093creches
credit9315193credi_t
credos94612853cre_dos
creds85418773cre__ds
creeds94714773cre_eds
creeks124812923cre_eks
creels84416943cre_els
creepies1239613creepies
creeps104213623cre_eps
creeses93914623creeses
cremains1238693cremains
cremes104517993cre_mes
cremini11229063cremini
creminis12208253creminis
crenels93711013crenels
creoles9913323creoles
crepes105419343cre_pes
crepier1139743crepier
crepiest12310383crepiest
creping122913653creping
crepons1139323crepons
cresols939653cresols
cress75022833cre__ss
cresses94219813cresses
cresting114017043cresting
crestings12298043crestings
crests85218703cre_sts
cresyls1234753cresyls
cretinism1347123cretinism
cretinous1145893cretinous
creviced1634453creviced
crewels12438493crewels
crewing133212633crewing
crews105917503cre__ws
cribs94516753cr__ibs
cricetids1443893cricetids
crick135118753cr__ick
cricks144316053cr__icks
cries75438403cr__ies
cris66233433cr__i_s
crisic103611843crisic_
crisis83716343crisi_s
critical12310263critical
criticise1356453criticise
criticism1556843criticism
crits75527573cr__its
crocs95722433cr__ocs
crojiks2033173crojiks
cronies9622503cronies
crotch133410083crot_ch
crotons93714373crotons
cruelties1144893cruelties
cruets85314953cruet__s
crutch13408243crut_ch
crwths1433433crwt_hs
cryonics1555413cryonics
cryptic1646153cryptic_
cubics123810163c_ubics
cultic105111903cultic_
curets84922343curet__s
curettes1039313curettes
cuties84927363c_uties
cutins83919983c_utins
cutis77723763c_uti_s
cutties93118843cutties
cyesis1148573cyesi_s
cynics13377363c_ynics
cystic132710653cystic_
detick1339383_detick
deticks1437353_deticks
diuretics1244953diuretics
dreich12377723dre_ich
eclectics1254813eclectics
emetic10614453emetic_
emetins9812653emetins
enuretics1145063enuretics
epics95014283__epics
erethic1257723erethic_
eristics10610193eristics
erotic82620273erotic_
erotica92811513erotica
erratics1046983erratics
ethics11169283__ethics
etic66123953__etic_
exotics16229193exotics
fetich1479693_fetich
frenetics1444603frenetics
frets85523403fret__s
frolics1236833frolics
fustics1279593fustics
genetics11128613genetics
gratins84119183gratins
gratis74819243grati_s
herdics13249523herdics
heretic12314833heretic_
heroics122912003heroics
icterics1247053icterics
irenic8311103irenic_
iritic83213823iritic_
iritis63113733iriti_s
kinetics14207253kinetics
luetic8310383luetic_
mastics112614783mastics
medics114115353_medics
memetics1447803memetics
metis75025903_meti_s
metrics11312363_metrics
miotics112710653miotics
myotics14257603myotics
mystics14279103mystics
noetic8514043noetic_
optics102810183_optics
orectic1138823orectic_
paretic113016673paretic_
peptics132610243peptics
photics142810483photics
pieties9419223pieties
poetic10416843poetic_
prebids12399883prebids
precis103416703preci_s
predict12315323predict
predicts1339613predicts
prelims1139823prelims
premies113823063premies
premiss113513813premiss
prentice121012353prentice
prentices131111903prentices
pretors9316813pretors
pretrims1238983pretrims
pretties10615133pretties
prexies163415003prexies
pyretic143210783pyretic_
ratios64922673_ratios
rebecs103913673_rebecs
rebids94015533_rebids
recits83621353_recits
recs65734183_re__cs
redias74523603_redias
redips93713843_redips
refits94017653_refits
regius7311923_regius
reifs84819093_re_ifs
reins56234563_re_ins
reis45343233_re_i_s
rejigs14368093_rejigs
relic74623363_relic_
relict83623903_relict
relicts94414593_relicts
relies65036423_relies
remiss84216353_remiss
remits85622943_remits
renigs74314593_renigs
renins64526453_renins
reoils64516873_reoils
repins84924313_repins
rerigs74014793_rerigs
resids74219153_resids
resins64528773_resins
resits64725563_resits
retack122612823_retack
retacks132210713_retacks
retags73414303_retags
retails74718973_retails
retains74522253_retains
retch104818303_ret_ch
retems83914573_retems
retia55326113_reti_a
retial64724993_retial
reticle94112623_reticle
reticles103912483_reticles
retie55735303_reti_e
retied75924983_retied
retile65929673_retile
retiles74426993_retiles
retime85321803_retime
retimes95020173_retimes
retina65023383_retina
retinas74819353_retinas
retine66237333_retine
retines75134673_retines
retint65633443_retint
retints74717013_retints
retire64927013_retire
retires74726213_retires
retries74129073_retries
retrims93612373_retrims
retros63820193_retros
rets45352563_ret__s
rewins95020823_rewins
rotis56327063_roti_s
rustics9810733rustics
rutins63818393_rutins
scenics1137773scenics
sceptics1455663sceptics
sciatics12117273sciatics
secretins11108463secretins
septics112810433septics
sferics1236133sferics
skeptics1653863skeptics
statics93314533statics
sureties8316583sureties
tabetics1245683tabetics
tactics1149323tactics
thetic11412893thetic_
tics65729633___tics
tonetics1048943tonetics
toreutics1143543toreutics
tragics10338083tragics
treaties8316983treaties
trets55928023tret__s
tropics113610653tropics
uratic83016353uratic_
ureic74514463ure_ic_
uremias9249503uremias
uremic103410513uremic_
ureters7311823ureters
vertices13612283vertices
wretch14326533wret_ch
yetis85418393_yeti_s

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 Limit1340273296.86019537.5
3Display Results3293290.1232674.8
 (SQL Overall)1786913297.38924183.4
 
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.