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 “explanation” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

141 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
explanation204526(None) 
explanations2144621explanations
explantation2153971explantation
exclamation22104632exclamation
explanative2353102explanative
explantations2253642explantations
explication2248452explication
exploration2066712exploration
planation11310122__planation
emanation11910783e__manation
exaltation1748493exal_tation
examination2058453examination
excavation2245433ex_cavation
exclamations23104103exclamations
exhalation2046653ex_halation
exhilaration2252523exhilaration
expansion1844443exp_an_sion
expatiation2046833expatiation
expectation2266483expectation
expiation18710423exp__iation
expiration19610713exp_iration
explanatory2352603explanatory
explanting2045223explan_ting
explications2347533explications
exploitation2154703exploitation
explorations2185613explorations
exportation2047443exportation
expunction2143573exp_unction
expurgation2154553expurgation
exultation1747533exul_tation
implantation1653353implantation
placation1339773__placation
planations1238723__planations
plantation1248533__plantation
replantation1445523replantation
acclamation17144754acclamation
aplanatic1344904_aplanati_c
application1747474application
clavation1447004__clavation
declamation1646104declamation
declaration1447834declaration
declination14411874declination
depravation1785694depravation
desalination13411134desalination
dilatation1147394_dilatation
duplication1647294duplication
elation73620454e__l__ation
elevation1239234e__levation
elimination1348534elimination
elongation1145354e__longation
emanations1289594e__manations
emulation11312394emul__ation
enation73419234e____nation
epilation11312964e_p_ilation
escalation1248874e_scalation
evagination1546564evagination
evaluation1358184eval_uation
exaction1738954ex__a_ction
exaltations1847294exal_tations
examinations2167464examinations
excavations2345084ex_cavations
excitation19410174ex_citation
excoriation2048434excoriation
exculpation2244874exculpation
execration1949834ex_ecration
exfoliation2145254exfoliation
exhalations2146024ex_halations
exhaustion2052884ex_haustion
exhilarations2352414exhilarations
exhortation2145024exhortation
exhumation2244694ex_humation
exoneration1847654exoneration
expansions1944154exp_an_sions
expatiations2146134expatiations
expatriation2154334expatriation
expectations2365844expectations
expedition2044904exp_edition
expiations1959664exp__iations
expirations2069584exp_irations
explain1667044expl__a_i_n
explanatively2861824explanatively
explanatorily2561054explanatorily
explant16310134explan_t___
explanted1944974explan_t_ed
explants1737024explan_t__s
explicating2356124explicating
explicative2554454explicative
explicator2145154explicat_or
exploitations2254214exploitations
explorational2252554explorational
explorative2354244explorative
explosion18115214expl__osion
exportations2146654exportations
exposition1947164exp_osition
expunctions2243634exp_unctions
expurgations2274124expurgations
exsiccation2243624exsiccation
extenuation1845184extenuation
extinction1944774ex_tinction
extirpation2084924extirpation
extraction1967984extra_ction
extradition1954504extradition
extrication2049794extrication
exudation1787694ex__udation
exultations1846524exul_tations
exuviation20116344ex_uviation
hyphenation22123964hyphenation
implantations1753244implantations
implication1747774implication
inclination1349734inclination
lavation1139974___lavation
laxation1538424___laxation
lunation8311924___lunation
methanation1644534methanation
oxygenation2252874oxygenation
palmation13310224__palmation
palpation1339074__palpation
phonation1439394__phonation
pinnation1138014__pinnation
placations1438584__placations
planarian1147114__planarian
plankton1443854__plankt_on
plantain1047904__plantai_n
plantations1347474__plantations
plication13311684__plication
pollination1348014pollination
profanation16186104profanation
pronation11415704__pronation
reclamation1546354reclamation
reimplantation1861934reimplantation
relaxation1746454_relaxation
reparation12612724rep_aration
replantations1544864replantations
replication15712014replication
separation12510434sep_aration
sexploitation2252954sexploitation
spallation1247024_spallation
supernation13411664supernation
supination1249884sup_ination
supplantation1762664supplantation
trepanation1345484trepanation

Search took 10 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 Filter1786911488190.406440125.6
2DLD Change Limit1488191419.36015899.5
3Display Results1411410.0801762.5
 (SQL Overall)1786911419.84618148.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.