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

205 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
edition831085(None) 
editions9310401editions
sedition939331sedition
addition1096892addition
audition979172audition
coition9314312coition
diction102313052_diction
editing9313132editing
editor738662edit_or
eduction1169052eduction
elation73620452elation
elision72311102elision
elution72913822elution
emotion9711302emotion
enation73419232enation
erudition1046172erudition
eviction13228682eviction
lenition8310082lenition
mediation12312292mediation
perdition1249012perdition
petition10711752petition
reedition1047832reedition
rendition1058932rendition
sedation9312452sedation
seditions1039012seditions
tuition738822tuition
vendition1345692vendition
action84719683_action
adaption1145643adaption
addiction13146013addiction
additions1186333additions
adnation9310783adnation
adoption1146083adoption
aeration8319933aeration
alation72920553alation
ambition1246563ambition
amotion9710473amotion
auction93412933auction
auditions1078753auditions
aviation11312743aviation
bastion9312473bastion
caption113513693caption
cation83925503_cation
caution93013523caution
chitin113114963chiti_n
chiton112612393chit_on
citron83112983_citron
coitions10312853coitions
condition12411163condition
decision1148523decision
dedication14311963dedication
deduction1377083deduction
deities82621923deities
delation92318083delation
deletion92011973deletion
demotion1169073demotion
dentin73919573denti_n
dentition1049633dentition
depiction1437273depiction
derision939073derision
detrition1049133detrition
deviation13312393deviation
devotion1256763devotion
diatron839283_diatron
dictions111812673_dictions
dilation92215463_dilation
dilution9239143_dilution
dithiol1145433_dithiol
ditto65315603_ditto_
dittos74111973_dittos
diuron738573_diuron
durion7510963_durion
edifice1344933edifice
edified12339713edified
edifier11309263edifier
edifies113012283edifies
edit54934863edit___
edited83913673edit_ed
editors839423editors
editrix1543643editrix
edits65819033edit__s
education12310203education
eductions1268773eductions
egestion946863egestion
eidolon844913eidolon
eikon939463e_i_kon
ejection172510043ejection
elations83719123elations
election102015353election
elisions82210423elisions
elitism939763elitism
elitist7414913elitist
elusion72310953elusion
elutions82513053elutions
elytron1045463elytron
emetin8613463emeti_n
emission1047673emission
emoticon1273793emoticon
emotions10610283emotions
enations83316903enations
enditing10311073enditing
envision1145953envision
epigon937963epi_gon
epilation11312963epilation
epizoon1843813epizoon
equation17310483equation
erasion7311963erasion
erection102115513erection
erosion7311113erosion
eruditions1146103eruditions
eruption1047043eruption
ethion938813e_thion
evasion1036753evasion
evection131910833evection
evictions14228623evictions
eviting11511373eviting
exaction1738953exaction
excision1746273excision
exciton1646083excit_on
exertion15310083exertion
exilian1446963exilian
exiting15311393exiting
expedition2044903expedition
expiation18710423expiation
exudation1787693exudation
faction122613333faction
fetation11613143fetation
fiction122010733fiction
friction1347913friction
fruition11106103fruition
gelation93014433gelation
ideation9310493ideation
ignition946533ignition
indiction1239813indiction
inion54620183__inion
iodation9310383iodation
kation104315683_kation
lection92614863lection
legation92412933legation
lenitions939473lenitions
lotion65716523_lotion
mediations13310983mediations
medication15411173medication
meditation13410743meditation
mention9314373mention
minion83416243_minion
monition10311723monition
motion85217553_motion
munition1038763munition
nation64322803_nation
negation92913023negation
nidation9410583nidation
niton55418283_nit_on
notion64516583_notion
opinion946793opinion
option83612713_option
oration71617713oration
ovation101510023ovation
paction112713963paction
perditions1348873perditions
petitions11511083petitions
pinion83815893_pinion
piton76121583_pit_on
portion9615493portion
position10912193position
potion84519573_potion
predation12313463predation
prediction15410303prediction
punition1038373punition
radiation10313393radiation
ration64226013_ration
reaction10612603reaction
recision10310273recision
redaction1259663redaction
reduction1259903reduction
reeditions1147653reeditions
relation82619773relation
reliction11310693reliction
religion996743religion
remotion10410233remotion
renditions1149183renditions
revision1138713revision
ruction93611613ruction
section92515663section
sedations10311253sedations
seditious1046493seditious
seduction1266983seduction
seriation9318063seriation
station72717243station
stiction1038823stiction
suction93713043suction
sudation9310803sudation
taction93213023taction
titian62512663_titian
tradition1047593tradition
triton63914893trit_on
tuitions838283tuitions
unction9310663unction
venation11513503venation
venditions1445523venditions
vexation1838783vexation
virion9310683_virion
vision9311313_vision
volition1179173volition
waitron1036333waitron

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.420425454.8
2DLD Change Limit1340272057.04619021.7
3Display Results2052050.0802562.5
 (SQL Overall)1786912057.54623680.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.