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

163 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
evection13191083(None) 
ejection172510041ejection
election102015351election
erection102115511erection
evections142510691evections
eviction13228681eviction
advection1545552advection
defection151610642defection
dejection19178662dejection
detection121310412detection
eduction1169052eduction
egestion946862egestion
ejections18249962ejections
elections112414972elections
electron102611412electron
erections112515212erections
eversion1138712eversion
evictions14228622evictions
evocation142010292evocation
exaction1738952exaction
execution1846302execution
exertion15310082exertion
exsection1847492exsection
flection13239562flection
lection92614862_lection
refection141512282refection
rejection181710252rejection
resection111613272resection
section92515662_section
selection11311272selection
abjection2045323abjection
action84719683__action
advections1645553advections
affection1745893affection
auction93412933_auction
aversion1147313aversion
aviation11312743aviation
avocation14168993avocation
bijection20134793bijection
bilection13156803bilection
bisection13136983bisection
bolection13117673bolection
coaction12310773coaction
convection17411123convection
creation102816513creation
deception1448323deception
decoction1447523decoction
deduction1377083deduction
defecation1679803defecation
defections161510203defections
deflection16147733deflection
dejections20168353dejections
deletion92011973dele_tion
depiction1437273depiction
desertion10410203desertion
detections131410043detections
detention10169543detention
deviation13312393deviation
devotion1256763dev_otion
diction102313053_diction
direction1289783direction
edition8310853e_dition
education12310203education
eductions1268773eductions
egestions1046703egestions
ejecting18268163ejecting
ejective2037153ejective
ejector16378603eject_or
elation73620453e_lation
electing112113783electing
elective13311003elective
elector93313263elect_or
electro92810033electro_
electrons112411763electrons
electros102811753electros
elevation1239233elevation
elocution1145673elocution
elution72913823e_lution
emersion1047733emersion
emetin8613463eme_ti_n
emotion9711303e_motion
enation73419233e_nation
equation17310483equation
erectile1039513erectile
erecting112415063erecting
erective13311833erective
erector93513813erect_or
eruption1047043eruption
evacuation1547163evacuation
evasion1036753ev_asion
eventide1246853eventide
eversions1238363eversions
everting122213133everting
evertor1038723evert_or
evicting1437483evicting
evictor12346363evict_or
evocations15259873evocations
evolution12117093evolution
evulsion1155063evulsion
exactions1838923exactions
exception2046853exception
exciton1646083e_xciton
execration1949833execration
executions1946393executions
exemption2064943exemption
exertions1639763exertions
exsections1947633exsections
exsertion1646853exsertion
faction122613333_faction
fiction122010733_fiction
flections14239213flections
fraction1359483fraction
friction1347913friction
function1337843function
ideation9310493ideation
inaction1039623inaction
infection14410473infection
injection1838653injection
invention1248333invention
junction1736203junction
lectin82515013_lecti_n
lections102413843_lections
mention9314373_mention
objection2045093objection
ovation101510023ov_ation
overaction1547993overaction
paction112713963_paction
pectin102615533_pecti_n
perfection1748363perfection
plectron12228023plectron
prelection141511293prelection
prevention1549173prevention
question1745823question
reaction10612603reaction
reception13410323reception
redaction1259663redaction
reduction1259903reduction
reelection12198633reelection
refections151811643refections
reflection15168993reflection
rejections191510103rejections
reliction11310693reliction
resections121513033resections
retention91611483retention
revelation13410923revelation
reversion1248093reversion
revocation15410813revocation
ruction93611613_ruction
sanction1049533sanction
sections102714703_sections
seduction1266983seduction
selections12310873selections
stiction1038823stiction
suction93713043_suction
taction93213023_taction
traction10412683traction
unction9310663_unction
vacation131911893_vacation
vector113212063_vect_or
venation11513503venation
version10310923_version
vexation1838783vexation
vocation132311983_vocation

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 Limit1461621637.12320519.7
3Display Results1631630.0632587.3
 (SQL Overall)1786911637.60923484.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.