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

264 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
keratin11331415(None) 
ceratin93020161ceratin
keratins122313481keratins
aerating92821002aerating
aeration8319932aeration
berating113220762berating
ceratins102818732ceratins
certain92612212certain
creatin93618132creatin
derating103222282derating
gelatin83514732gelatin
gratin74520582_gratin
hematin121516022hematin
keramic1537232keramic
keratoid1347272keratoid
pertain92714962pertain
veratrin1147702veratrin
zeatin15412822ze_atin
acrasin9311223acrasin
aerate64830553aerat_e
aerated85322373aerated
aerates74627493aerates
aerations9317903aerations
aerator7314843aerator
beaten84617063be_aten
beating104326873be_ating
beraking153612973beraking
berate84729023berat_e
berated104422133berated
berates94126873berates
berlin83116373ber_lin
borating113414503borating
brain76229383_bra_in
carabin11313213carabin
carotin92216733carotin
ceramic1339823ceramic
cerate84829463cerat_e
cerated103922473cerated
cerates95428253cerates
ceratoid1149923ceratoid
cerotic11415063cerotic
cortin82423153cor_tin
crating103725203_crating
craton84517193_craton
creatine103417413creatine
creating113921953creating
creatins103617513creatins
creation102816513creation
cretin82917913_cretin
curating11314293curating
curtain9319793curtain
debating123213733debating
delating103119603delating
delation92318083delation
dentin73919573de_ntin
deraign936573deraign
derail74218813dera_il
derat65044083derat__
derate74531233derat_e
derated93623503derated
derates84028893derates
derats74625063derat_s
deratting1139513deratting
destain8412083destain
detain74617383deta_in
detrain8412253detra_in
drain65222893_dra_in
duration9312693duration
eaten55323053_e_aten
eating75134403_e_ating
elain55324703_ela_in
elastin72611843_elastin
elating83423083_elating
elation73620453_elation
emetin8613463_emetin
enatic8317563_enatic
enation73419233_enation
erasing8317963_erasing
erasion7311963_erasion
erotic82620273_erotic
erratic9311113erratic
etamin81311853_etamin
ferritin1147383ferritin
fetation11613143fetation
gelati73814533gelati_
gelatine93213303gelatine
gelating103015733gelating
gelatins93414093gelatins
gelation93014433gelation
gelatis83313513gelatis
gradin83517483_gradin
grain65126253_gra_in
gratine84719193_gratine
grating93923183_grating
gratins84119183_gratins
gratis74819243_gratis
greaten83610643greaten
gyrating1337453gyrating
gyration1237763gyration
haematin13148893haematin
hearten102411753hearten
hearting12513123hearting
heating114024323he_ating
hematein1387013hematein
hematic141816743hematic
hematine131614673hematine
hematins131714673hematins
heparin12410433heparin
hepatic141712773hepatic
herein93717793her_ein
heretic12314833heretic
heroin94420593her_oin
hieratic1349223hieratic
isatin6412213_isatin
iterating10314253iterating
iteration9515033iteration
jerkin17258113jer_kin
kain85334293k__a_in
karat96837593karat__
karate105320923karat_e
karates115617473karates
karats106420493karat_s
karstic1357983karstic
karting123716063kar_ting
karyotin15194833karyotin
kation104315683k__ation
kelvin13117323ke_lvin
kenotic1359713kenotic
kephalin1755643kephalin
keramics1644823keramics
keratinize23104763keratinize
keratinous1443573keratinous
keratitis1345873keratitis
keratoma1444333keratoma
keratose1245503keratose
keratosic1544503keratosic
keratosis1345733keratosis
keratotic1545643keratotic
kerbing14308483ker_bing
kerfing15307533ker_fing
kermis124012393ker_mis
kern85326213ker___n
kerning124010893ker_ning
kernite1159473kernite
kerogen1236083kerogen
kerosine1238143kerosine
kerria10339913ker_ria
ketamine14157053ketamine
ketotic1348643ketotic
kinetin11248263kinetin
komatik12135203komatik
korai97018523kora_i_
korat94934433korat__
korats105416063korat_s
krait94726773k_ra_it
kraits104912203k_raits
kraken955883k_raken
krater104014313k_rater
kremlin1344213kremlin
lectin82515013le_ctin
legatine91311403legatine
legating102313113legating
legation92412933legation
leptin82512333le_ptin
martin84122523mar_tin
matin75132853__matin
megaton10269853megaton
melanin9310893melanin
meriting11314683meriting
merlin83916683mer_lin
neaten64214543ne_aten
negating102012833negating
negation92913023negation
negaton8299143negaton
nematic111713993nematic
neritic91314333neritic
nervation12610243nervation
operatic1249933operatic
operating12313723operating
operation11314003operation
orating83520323_orating
oration71617713_oration
patin76832853__patin
pectin102615533pe_ctin
peracid12312993peracid
periti8319953periti_
pertains102113423pertains
piratic11314293piratic
pirating11314513pirating
prating103424453_prating
rain46251733__ra_in
ratan53722663__ratan
ratine65131823__ratine
rating74938703__rating
ratio55227583__ratio
ration64226013__ration
ratlin64116523__ratlin
ravin85624653__ravin
rawin85521473__rawin
reagin74915533re_agin
rebating112418343rebating
recrating121318793recrating
redating102620173redating
refrain10310043refra_in
regain74517763rega_in
regrating111316213regrating
relating92725443relating
relation82619773relation
relaxin14239183relaxin
remain85919863rema_in
remating112322413remating
reran57329103rera__n
retain64523283reta_in
retrain7615423retra_in
rutin55421343__rutin
satin55935223__satin
seating84130683se_ating
secretin10108343secretin
sedating103014113sedating
sedation9312453sedation
sematic111716873sematic
serai56830163sera_i_
serail64222673sera_il
serais64326133sera_is
seraphin1345953seraphin
serein63318463ser_ein
seriatim1049223seriatim
seriating10916403seriating
seriation9318063seriation
sericin9312843sericin
serin55434443ser__in
serotine8313573serotine
serotiny1148573serotiny
serrating10513203serrating
serration9414063serration
sextain14257103sextain
sprain83614863spra_in
statin63921473_statin
strain64919573stra_in
strati63518903strati_
terai53525483tera_i_
terais64023513tera_is
teratism10312173teratism
teratoid9411073teratoid
terrain7410853terrain
terrapin1046203terrapin
tertian7511193ter_tian
train56529113_tra_in
treating92519613treating
uprating11311113uprating
uratic83016353_uratic
venatic12311523venatic
venation11513503venation
veratria1146363veratria
veratrine1247753veratrine
veratrins1247753veratrins
verbatim1545033verbatim
verdin103113023ver_din
vermin113414523ver_min
vernation12311083vernation
vervain1335563vervain
vexation1838783vexation
xerotic16410863xerotic
zeatins16311733ze_atins

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.1401276364.3
2DLD Change Limit1340272646.39020974.5
3Display Results2642640.0962750.0
 (SQL Overall)1786912646.62626968.2
 
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.