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

244 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
keratins12231348(None) 
ceratins102818731ceratins
keratin113314151keratin_
aerating92821002aerating
aerations9317902aerations
berating113220762berating
ceratin93020162ceratin_
creatins103617512creatins
derating103222282derating
gelatins93414092gelatins
gratins84119182_gratins
hematins131714682hematins
keramics1644822keramics
keratinous1443572keratinous
keratitis1345872keratitis
pertains102113422pertains
veratrins1247752veratrins
zeatins16311732ze_atins
acrasins1039973acrasins
aerates74627493aerat_es
aeration8319933aeration
aerators8315613aerators
beating104326873be_ating
beatings114113233be_atings
beraking153612973beraking
berates94126873berat_es
berlins93216013ber_lins
borating113414503borating
brains85125473_bra_ins
carabins12312353carabins
carotins102315583carotins
ceramics1446803ceramics
cerates95428253cerat_es
certain92612213certain_
cortins92421333cor_tins
crating103725203_crating
cratons94316033_cratons
creatin93618133creatin_
creatine103417413creatine
creatines112814433creatines
creating113921953creating
creations112614543creations
cretins93216423_cretins
curating11314293curating
curtains10259703curtains
debating123213733debating
delating103119603delating
delations102616593delations
dentins83419223de_ntins
deraigns1034883deraigns
derails84216393dera_ils
derates84028893derat_es
derats74625063derat__s
deratting1139513deratting
destains9311813destains
detains83716093deta_ins
detrains9411763detra_ins
drains73719403_dra_ins
durations10311463durations
eating75134403_e_ating
eatings84616443_e_atings
elains64919853_ela_ins
elastins82111743_elastins
elating83423083_elating
elations83719123_elations
emetins9812643_emetins
emptins1179403_emptins
enations83316903_enations
erasing8317963_erasing
erasions8310983_erasions
erotics91914153_erotics
erratics1046983erratics
etamins91511833_etamins
ferities111416713ferities
ferritins1247273ferritins
fetations12511383fetations
gelatin83514733gelatin_
gelatine93213303gelatine
gelatines102910533gelatines
gelating103015733gelating
gelations102513093gelations
gelatis83313513gelati_s
gradins93416233_gradins
grains74223093_gra_ins
gratin74520583_gratin_
gratine84719193_gratine
grating93923183_grating
gratings103910763_gratings
gratis74819243_grati_s
greatens9307593greatens
gyrating1337453gyrating
gyrations1336923gyrations
haematins14147753haematins
heartens113010153heartens
hearties11315413hearties
hearting12513123hearting
heating114024323he_ating
hemateins1486173hemateins
hematics151712193hematics
hematin121516023hematin_
hematine131614673hematine
hematines141312203hematines
heparins13310123heparins
hepatics15198933hepatics
heretics13310503heretics
heroins103518013her_oins
isatins7310773_isatins
iterating10314253iterating
iterations10413823iterations
jerkins18358253jer_kins
kains96125643k__a_ins
karates115617473karat_es
karats106420493karat__s
karting123716063kar_ting
kartings13418523kar_tings
karyotins16234683karyotins
kations114013663k__ations
kelvins14106563ke_lvins
kephalins1854553kephalins
keramic1537233kerami_c
keratinize23104763keratinize
keratinizes24104803keratinizes
keratoid1347273keratoid
keratoma1444333keratoma
keratomas1544463keratomas
keratose1245503keratose
keratoses1346093keratoses
keratosis1345733keratosis
kerbing14308483ker_bing
kerfing15307533ker_fing
kermis124012393ker_mi_s
kerning124010893ker_ning
kernites1269113kernites
kerns94719563ker___ns
kerogens1345763kerogens
kerosine1238143kerosine
kerosines1357103kerosines
kerrias11289513ker_rias
kerries113317913ker_ries
ketamine14157053ketamine
ketamines15177033ketamines
kinetins12228153kinetins
komatiks13134013komatiks
korats105416063korat__s
kraits104912203k_ra_its
krakens1034293k_rakens
kraters114212343k_raters
kremlins1444483kremlins
lectins92515003le_ctins
legatine91311403legatine
legating102313113legating
legations102711923legations
leptins92412693le_ptins
martins93322063mar_tins
matins84527783__matins
megatons11279703megatons
melanins10310383melanins
meriting11314683meriting
merlins93015813mer_lins
neatens73310403ne_atens
negating102012833negating
negations102811963negations
negatons9299273negatons
nervations1359483nervations
operatics1346953operatics
operating12313723operating
operations12312953operations
orating83520323_orating
orations81515803_orations
patins87528783__patins
pectins112315233pe_ctins
peracids13310073peracids
pertain92714963pertain_
pirating11314513pirating
prating103424453_prating
rains55140233__ra_ins
ratans63819373__ratans
ratine65131823__ratine
ratines75328583__ratines
rating74938703__rating
ratings84217413__ratings
rations74123433__rations
ratios64922673__ratios
ratlins73615583__ratlins
ravins94622563__ravins
rawins95617623__rawins
reagins84215643re_agins
rebating112418343rebating
recrating121318793recrating
redating102620173redating
refrains1139593refra_ins
regains84316583rega_ins
regrating111316213regrating
relating92725443relating
relations92418333relations
relaxins15248683relaxins
remains94117903rema_ins
remating112322413remating
retains74522253reta_ins
retrains8314533retra_ins
rutins63818393__rutins
satins64930483__satins
seating84130683se_ating
seatings93614303se_atings
secretins11108463secretins
sedating103014113sedating
sedations10311253sedations
serails73318363sera_ils
serais64326133sera_i_s
sereins73716113ser_eins
seriating10916403seriating
seriations10316683seriations
sericins10312463sericins
serins64029673ser__ins
serotine8313573serotine
serotines9312073serotines
serotiny1148573serotiny
serrating10513203serrating
serrations10313093serrations
sextains15246813sextains
sprains93013593spra_ins
statins73719773_statins
strains74218153stra_ins
terais64023513tera_i_s
teratism10312173teratism
teratisms11410073teratisms
terrains8410323terrains
terrapins1146183terrapins
tertians839103ter_tians
trains64725343_tra_ins
treaties8316983treaties
treating92519613treating
uprating11311113uprating
venations12311723venations
veratrias1246563veratrias
veratrin1147703veratrin_
veratrine1247753veratrine
veratrines1347263veratrines
verdins112812333ver_dins
verities111418043verities
vernations13310333vernations
vervains1435293vervains
vexations1937753vexations
zeatin15412823ze_atin_

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 Filter1786911461620.326548131.9
2DLD Change Limit1461622447.48319532.5
3Display Results2442440.0962541.7
 (SQL Overall)1786912447.90522604.8
 
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.