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

155 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
ejection17251004(None) 
dejection19178661dejection
ejections18249961ejections
election102015351election
erection102115511erection
evection131910831evection
rejection181710251rejection
abjection2045322abjection
bijection20134792bijection
defection151610642defection
dejections20168352dejections
detection121310412detection
eduction1169052eduction
egestion946862egestion
ejecting18268162ejecting
ejective2037152ejective
ejector16378602eject_or
elections112414972elections
electron102611412electron
erections112515212erections
evections142510692evections
eviction13228682eviction
exaction1738952exaction
execution1846302execution
exertion15310082exertion
exsection1847492exsection
flection13239562flection
injection1838652injection
lection92614862_lection
objection2045092objection
refection141512282refection
rejections191510102rejections
resection111613272resection
section92515662_section
selection11311272selection
abjections2145673abjections
action84719683__action
advection1545553advection
affection1745893affection
auction93412933_auction
bijections21134933bijections
bilection13156803bilection
bisection13136983bisection
bolection13117673bolection
coaction12310773coaction
creation102816513creation
deception1448323deception
decoction1447523decoction
deduction1377083deduction
defecation1679803defecation
defections161510203defections
deflection16147733deflection
dejecting20217793dejecting
deletion92011973dele_tion
depiction1437273depiction
desertion10410203desertion
detections131410043detections
detention10169543detention
diction102313053_diction
direction1289783direction
edition8310853e_dition
education12310203education
eductions1268773eductions
egestions1046703egestions
eject145016043eject___
ejecta15337393eject__a
ejected17297653eject_ed
ejectives2145443ejectives
ejectment2044823ejectment
ejectors17328663ejectors
ejects15409953eject__s
elation73620453e_lation
electing112113783electing
elective13311003elective
elector93313253elect_or
electro92810033electro_
electrons112411753electrons
electros102811743electros
elevation1239233elevation
elocution1145673elocution
elution72913823e_lution
emersion1047733emersion
emetin8613463eme_ti_n
emotion9711303e_motion
enation73419233e_nation
equation17310483equation
erectile1039513erectile
erecting112415063erecting
erective13311833erective
erector93513813erect_or
eruption1047043eruption
eversion1138713eversion
evictions14228623evictions
evocation142010293evocation
exactions1838923exactions
exception2046853exception
exciton1646083e_xciton
execration1949833execration
executions1946393executions
exemption2064943exemption
exertions1639763exertions
exsections1947633exsections
exsertion1646853exsertion
faction122613333_faction
fiction122010733_fiction
flections14239213flections
fraction1359483fraction
friction1347913friction
function1337843function
ideation9310493ideation
inaction1039623inaction
infection14410473infection
injections1948663injections
jeton124815403_je_t_on
jettison1542503_jettison
jetton1338033_je_tton
junction1736203junction
lectin82515013_lecti_n
lections102413843_lections
mention9314373_mention
objections2145633objections
paction112713963_paction
pectin102615533_pecti_n
perfection1748363perfection
plectron12228023plectron
prelection141511293prelection
projection2158763projection
question1745823question
reaction10612603reaction
reception13410323reception
redaction1259663redaction
reduction1259903reduction
reelection12198633reelection
refections151811643refections
reflection15168993reflection
reinjection2044583reinjection
rejecting192211153rejecting
rejective2148253rejective
rejector17237723reject_or
reliction11310693reliction
resections121513033resections
retention91611483retention
ruction93611613_ruction
sanction1049533sanction
sections102714703_sections
seduction1266983seduction
selections12310873selections
stiction1038823stiction
subjection2165973subjection
suction93713043_suction
surjection1974903surjection
taction93213023_taction
traction10412683traction
trajection1944693trajection
unction9310663_unction

Search took 7 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.406440125.6
2DLD Change Limit1461621556.34323043.0
3Display Results1551550.0632460.3
 (SQL Overall)1786911556.81226231.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.