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

119 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
exertion1531008(None) 
exertions1639761exertions
exsertion1646851exsertion
desertion10410202desertion
egestion946862egestion
ejection172510042ejection
election102015352election
emersion1047732emersion
erection102115512erection
evection131910832evection
eversion1138712eversion
exaction1738952exaction
exception2046852exception
excerption2145062excerption
excretion1846712excretion
execration1949832execration
execution1846302execution
exemption2064942exemption
exerting162211152exerting
exertive1839082exertive
exsection1847492exsection
exsertions1746742exsertions
extortion1646722extortion
abortion1048103abortion
aeration8319933_aeration
assertion946723assertion
aversion1147313aversion
coercion1246573coercion
creation102816513creation
deaeration11313013deaeration
deception1448323deception
defection151610643defection
dejection19178663dejection
deletion92011973dele_tion
desertions1139883desertions
detection121310413detection
detention10169543detention
edition8310853e_dition
eduction1169053eduction
egestions1046703egestions
ejections18249963ejections
elation73620453e_lation
elections112414973elections
electron102611413electron
elevation1239233elevation
elution72913823e_lution
emersions1147283emersions
emetin8613463eme_ti_n
emotion9711303e_motion
enation73419233e_nation
enervation1369473enervation
equation17310483equation
erections112515213erections
eruption1047043eruption
evections142510693evections
eversions1238363eversions
everting122213133everting
evertor1038723evert_or
eviction13228683eviction
exactions1838923exactions
exceptions2146863exceptions
excerptions2244983excerptions
excision1746273excision
exciton1646083excit_on
excretions1946623excretions
excursion1844613excursion
execrations2048923execrations
executions1946393executions
exemptions2164833exemptions
exercise1747063exercise
exert124624143exert___
exerted152210053exert_ed
exerts133712293exert__s
exoneration1847653exoneration
expedition2044903expedition
experting1938053experting
expertise1847933expertise
expertism2045433expertism
expertize2746583expertize
expiation18710423expiation
expiration19610713expiration
exsections1947633exsections
exsertile1644593exsertile
exserting1736663exserting
extension1646293extension
exterior1547373exter_ior
extortions1746473extortions
extraction1967983extraction
extrusion1645253extrusion
exudation1787693exudation
federation1449573federation
fermion1236763_fermion
flection13239563flection
generation11312423generation
ideation9310493ideation
insertion9410593insertion
iteration9515033iteration
lection92614863_lection
mention9314373_mention
operation11314003operation
pereion9312053_pereion
portion9615493_portion
question1745823question
reception13410323reception
refection141512283refection
rejection181710253rejection
resection111613273resection
retention91611483retention
retortion949673retortion
reversion1248093reversion
secretion11118303secretion
section92515663_section
selection11311273selection
ternion739493_ternion
tertian7511193_tertian
thermion1345933thermion
veneration13412343veneration
version10310923_version
vexation1838783vex_ation

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.420425454.8
2DLD Change Limit1461621197.25320151.9
3Display Results1191190.0462587.0
 (SQL Overall)1786911197.71923149.5
 
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.