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

256 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
creation10281651(None) 
creatin93618131creati_n
creations112614541creations
cremation13511641cremation
crenation11412921crenation
aeration8319932aeration
carnation11312942carnation
caseation1199512caseation
cation83925502c__ation
ceratin93020162cerati_n
chelation1439962chelation
citation10314362citation
conation101420882conation
craton84517192cr_at_on
creatine103417412creatine
creating113921952creating
creatins103617512creatins
creative132812802creative
creator93714432creat_or
cremations14410712cremations
crenations12511692crenations
cretin82917912cre_ti_n
erection102115512erection
ideation9310492ideation
oration71617712or_ation
predation12313462predation
ration64226012_r_ation
reaction10612602_reaction
recreation12413612recreation
relation82619772_relation
ablation10312433ablation
abreaction1444653abreaction
accretion1345933accre_tion
actuation11310333actuation
acylation1448653acylation
adnation9310783adnation
aerations9317903aerations
agnation9311723agnation
alation72920553_alation
arcuation11410583arcuation
aviation11312743aviation
camion103917193c__amion
caption113513693c_aption
carbanion1345943carbanion
carnations12311353carnations
caseations1258303caseations
cassation1197913cassation
catenation1249523catenation
cations94524143c__ations
caudation1269993caudation
causation1199523causation
caution93013523c_aution
ceratins102818733ceratins
ceratoid1149923ceratoid
cerebration1547923cerebration
certain92612213certai_n
cessation1176853cessation
cession939813c_ession
cheating144014523cheating
chelations1539073chelations
ciliation111112493ciliation
citations11312503citations
clarion9311663c_larion
clavation1447003clavation
cleating113518133cleating
coaction12310773coaction
coercion1246573coercion
cognation12310753cognation
coition9314313c_oition
collation11313993collation
conations111318903conations
connation11314263connation
cooption1288343cooption
copatron1246753copatron
coronation12412073coronation
corotation12410973corotation
corrasion1146483corrasion
correction1448813correction
correlation1358553correlation
crampon1336943cr_ampon
crating103725203cr_ating
cratons94316033cr_at_ons
crayon114110003cr_a_yon
creakier14328333creakier
creakily1735393creakily
creaking153414123creaking
creamier12319063creamier
creamily1536363creamily
creaming133413143creaming
creasier103210193creasier
creasing113314443creasing
create85126383creat__e
created104323453creat_ed
creates95225203creat_es
creatines112814433creatines
creatinine1245073creatinine
creationism1576463creationism
creationist1379233creationist
creatives14279693creatives
creators102814403creators
creature1038723creature
creditor1145893creditor
cremating14312193cremating
cremator1269173cremat_or
crenelation1346853crenelation
crenulation1347573crenulation
crepitation1548393crepitation
crepon1039933cre__pon
cresting114017043cresting
cretic102816283cre_ti_c
cretics112911653cre_tics
cretins93216423cre_tins
crostino1038883crostino
croton84415453cr_ot_on
crouton947133crout_on
cryotron1344373cryotron
darnation1039823darnation
delation92318083delation
dilation92215463dilation
direction1289783direction
donation91513783donation
dotation91412733dotation
duration9312693duration
egestion946863egestion
ejection172510043ejection
elation73620453_elation
election102015353election
elevation1239233elevation
enation73419233_enation
equation17310483equation
erasion7311963er_asion
erections112515213erections
eruption1047043eruption
evection131910833evection
excretion1846713excre_tion
exertion15310083exertion
fetation11613143fetation
fixation1837073fixation
flection13239563flection
formation1439423formation
fraction1359483fraction
friction1347913friction
fruition11106103fruition
furcation1448353furcation
gelation93014433gelation
gradation11107713gradation
gratin74520583gr_ati_n
greaten83610643great_en
gyration1237763gyration
halation11313853halation
himation1339753himation
ideations1039903ideations
illation8311943illation
incretion1149053incre_tion
iodation9310383iodation
iteration9515033iteration
kation104315683__kation
keratin113314153kerati_n
laceration1249573laceration
laureation1046153laureation
lavation1139973lavation
laxation1538423laxation
lection92614863_lection
legation92412933legation
libation102411363libation
ligation92313093ligation
lineation9310763lineation
lobation102110553lobation
location102113913location
lunation8311923lunation
luxation1538233luxation
maceration1449613maceration
mention9314373_mention
miscreation1547723miscreation
mutation101412883mutation
narration9310063narration
natation81513933natation
nation64322803__nation
negation92913023negation
nervation12610243nervation
nidation9410583nidation
notation81414603notation
novation111710013novation
nucleation1245963nucleation
nutation81513103nutation
oblation1039863oblation
operation11314003operation
orations81515803or_ations
ovation101510023_ovation
permeation14410563permeation
potation101716783potation
precaution1447243precaution
predations13812153predations
prenotion1149173prenotion
preoption1348083preoption
preunion1046893preunion
privation14311173privation
proaction13410103proaction
probation13412183probation
procreation1547953procreation
pronation11415703pronation
proration11415983proration
pupation1269503pupation
purgation1247393purgation
question1745823question
ratio55227583_r_atio_
rations74123433_r_ations
ratios64922673_r_atios
ratoon64417373_r_atoon
ratton64116123_r_atton
reactions11711713_reactions
reagin74915533_reagi_n
realign838763_realign
reason62616333_rea_son
recaution1148093_recaution
recreations13412253recreations
redaction1259663_redaction
reflation12412333_reflation
region74614903_re_gion
relations92418333_relations
remotion10410233_remotion
restation9316913_restation
retain64523283_retai_n
reunion737673_reunion
rogation91612053rogation
rotation81615453rotation
ruction93611613_ruction
scalation11311073scalation
secretion11118293secre_tion
section92515663_section
sedation9312453sedation
seriation9318063seriation
serration9414063serration
solation8916153solation
station72717243_station
striation9313483striation
sudation9310803sudation
tarnation9310093tarnation
taxation1537993taxation
trabeation1245883trabeation
traction10412683traction
treason748763trea_son
treaties8316983treaties
treating92519613treating
treatise8311103treatise
ulceration1247263ulceration
urination9312173urination
vacation131911893vacation
variation12312393variation
venation11513503venation
vernation12311083vernation
vexation1838783vexation
vocation132311983vocation
wreathen14256143wreathen
zeatin15412823_zeati_n
zonation171410723zonation

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 Limit1461622567.04620744.0
3Display Results2562560.1102327.3
 (SQL Overall)1786912567.57923577.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.