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

321 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
creatins10361751(None) 
ceratins102818731ceratins
creatin93618131creatin_
creatine103417411creatine
creatines112814431creatines
creating113921951creating
creations112614541creations
cretins93216421cre_tins
ceratin93020162ceratin_
cheating144014522cheating
cleating113518132cleating
crating103725202cr_ating
cratons94316032cr_atons
creaking153414122creaking
creaming133413142creaming
creasing113314442creasing
creates95225202creat_es
creation102816512creation
creative132812802creative
creatives14279692creatives
creators102814412creators
cremains1238692cremains
cremating14312192cremating
cremations14410712cremations
crenations12511692crenations
cresting114017042cresting
crestings12298042crestings
cretics112911652cre_tics
cretin82917912cre_tin_
gratins84119182gr_atins
greatens9307592greatens
keratins122313482keratins
reagins84215642_reagins
retains74522252_retains
treaties8316982treaties
treating92519612treating
zeatins16311732_zeatins
acetins9313173ace_tins
acrasins1039973acr_asins
aerating92821003aerating
aerations9317903aerations
beating104326873_beating
beatings114113233_beatings
berating113220763berating
bleating113514503bleating
brains85125473br_a_ins
breading123515463breading
breaking153914253breaking
breakings16297063breakings
breaming133612513breaming
breasting1239583breasting
breastpins1442713breastpins
breathes134212903breathes
breathing15218373breathing
breathings16234313breathings
breaths124411183breat_hs
cabins104418923c__abins
cains75334303c__a_ins
canakins142010463canakins
captains121810573captains
carabins12312353carabins
carnations12311353carnations
carotins102315583carotins
carrotins11239963carrotins
caryatids1545223caryatids
caryotins14248043caryotins
caseating12311743caseating
caseations1258303caseations
cations94524143c__ations
catkins133012563c__atkins
catlins93818843c__atlins
cavatina1347333cavatina
cavatinas1444783cavatinas
cavatine13310323cavatine
caveating1539293caveating
ceasing104118263c_easing
ceramics1446803ceramics
cerates95428253cerat_es
certain92612213certain_
chains114819703c_ha_ins
cheapens15305943cheapens
cheapies1539033cheapies
cheaters133613513cheaters
cheats114519543cheat__s
chelating1549353chelating
chelations1539073chelations
chitins122713793c_hitins
chromatins1749123chromatins
citations11312503citations
cleaning113112383cleaning
cleans85817053clea__ns
clearing113014883clearing
clearings12286063clearings
cleats84919313cleat__s
cleaving141389683cleaving
clefting14347583clefting
clematis1248653clemati_s
coating103525313c_oating
coatings113811843c_oatings
coatis85122603c_oati_s
cocains111313923coca_ins
cocreating15310293cocreating
comatiks16148043comatiks
conations111318903conations
contains10316533contains
corelating13511583corelating
cortins92421333c_ortins
craaling112711353craaling
crafting143710173crafting
craning103620303cr_aning
craping124018713cr_aping
crasis85020473cr_asi_s
craters95021893cr_aters
crates85736063cr_at_es
craton84517193cr_aton_
cravens124010113cr_avens
craving134015733cr_aving
cravings14428223cr_avings
crayons12439233cr_ayons
crazies183413853cr_azies
crazing193914583cr_azing
creakier14328333creakier
creakiest15238593creakiest
creakily1735393creakily
creakiness1645963creakiness
creaks124315963crea__ks
creamers124111313creamers
creamier12319063creamier
creamiest13248933creamiest
creamily1536363creamily
creaminess1446203creaminess
creams104715253crea__ms
creasers103612833creasers
creases94020963crea_ses
creasier103210193creasier
creasiest11229943creasiest
create85126383creat__e
created104323453creat_ed
creatinine1245073creatinine
creatinines1344043creatinines
creationism1576463creationism
creationist1379233creationist
creator93714443creat_or
creature1038733creature
creatures1138413creatures
crediting1338843crediting
credits1039973cre_dits
creeling113513363creeling
creepies1239613creepies
creeping133310103creeping
cremates124216003cremat_es
cremation13511643cremation
cremators1369813cremators
cremini11229063cre_mini
creminis12208253cre_minis
crenation11412923crenation
creping122913653cre_ping
crepons1139323cre_pons
crests85218703crest__s
cretic102816283cre_ti_c
cretinism1347123cre_tinism
cretinous1145893cre_tinous
crewing133212633cre_wing
critics112811093cr_itics
croaking153712163croaking
croceins1238103croceins
crostini1038293crostini
crostino1038883crostino
crotons93714373cr_otons
croutons1036753croutons
cruelties1144893cruelties
crusting113612793crusting
cumarins1238643cumarins
curating11314293curating
curetting1236573curetting
curtains10259703curta_ins
cutins83919983c__utins
cyanins122910013c_yanins
cycasins1545283cycasins
dentins83419223_dentins
derating103222283derating
detains83716093_detains
drains73719403dr_a_ins
dreading113712803dreading
dreaming124011063dreaming
drearies92313413drearies
eating75134403__eating
eatings84616443__eatings
emetins9812643eme_tins
erecting112415063erecting
erections112515213erections
erepsins1037443erepsins
erratics1046983erratics
freaking163611453freaking
fretting122711523fretting
gelatins93414093gelatins
gradins93416233gr_adins
grains74223093gr_a_ins
gratin74520583gr_atin_
gratine84719193gr_atine
grating93923183gr_ating
gratings103910763gr_atings
gratis74819243gr_ati_s
greasing102811393greasing
greaten83610643greaten_
greats76318393great__s
greeting103112353greeting
greetings11276043greetings
gremlins1136043gremlins
haematins14147753haematins
heating114024323_heating
hematins131714683hematins
ideating10311703ideating
ideations1039903ideations
isatins7310773_isatins
keratin113314153keratin_
kremlins1444483kremlins
lectins92515003_lectins
leptins92412693_leptins
matins84527783__matins
neatens73310403_neatens
orating83520323or_ating
orations81515803or_ations
ordains879653orda_ins
pancreatins1553843pancreatins
patins87528783__patins
pectins112315233_pectins
pertains102113423pertains
pleating112916053pleating
prating103424453pr_ating
preacting142412533preacting
predating13514653predating
predations13812153predations
pretties10615133pretties
rains55140233_r_a_ins
ratans63819373_r_atans
ratine65131823_r_atine
ratines75328583_r_atines
rating74938703_r_ating
ratings84217413_r_atings
rations74123433_r_ations
ratios64922673_r_atios
ratlins73615583_r_atlins
ravins94622563_r_avins
rawins95617623_r_awins
reacting113317893_reacting
reactions11711713_reactions
readies83324713_readies
reading93327213_reading
readings103512643_readings
reagin74915533_reagin_
realigns936253_realigns
realties8514853_realties
reaming103924013_reaming
reaping103621213_reaping
rearing83128783_rearing
reasons72514943_reasons
reatas64021013_reat_as
reattains946443_reattains
reaving113820533_reaving
rebating112418343_rebating
recoins94019243_recoins
recreating131214583recreating
recreations13412253recreations
redating102620173_redating
redfins1139923_redfins
regains84316583_regains
reins56234563_re__ins
rejoins143111383_rejoins
relating92725443_relating
relations92418333_relations
relaxins15248683_relaxins
remains94117903_remains
remating112322413_remating
renins64526453_re_nins
rennins74013413_rennins
renting84026853_renting
repins84924313_re_pins
requins16310203_requins
resins64528773_re_sins
resting85031183_resting
retails74718973_retails
retain64523283_retain_
reties65436193_re_ties
retina65023383_re_tina
retinas74819353_re_tinas
retine66237333_re_tine
retines75134673_re_tines
retint65633443_re_tint
retints74717013_re_tints
retting83425883_retting
rewins95020823_re_wins
rutins63818393_r_utins
satins64930483__satins
screaking16228243screaking
screaming14217833screaming
seating84130683_seating
seatings93614303_seatings
secretins11108463secre_tins
statins73719773_statins
stearins8312143stearins
sweating123213023sweating
threatens1254673threatens
threating131010053threating
trains64725343tr_a_ins
treading103515333treading
treasons848683treasons
treaters83615843treaters
treatise8311103treatise
treatises9310373treatises
treats64821693treat__s
triazins1738353triazins
uncreating13310473uncreating
veratrins1247753veratrins
wheatens1454663wheatens
wreaking163010213wreaking
wreathes14299893wreathes
wreathing16266313wreathing
wreaths13338373wreat_hs
wresting123811833wresting
zeatin15412823_zeatin_

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.423422437.4
2DLD Change Limit1461623217.22020244.0
3Display Results3213210.1232609.8
 (SQL Overall)1786913217.76623009.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.