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

174 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
deletion9201197(None) 
delation92318081delation
deletions102610931deletions
depletion1256661depletion
dealation10313002dealation
deception1448322deception
defection151610642defection
deflation13310652deflation
deflection16147732deflection
deflexion2042822deflexion
dejection19178662dejection
delations102616592delations
delegation1238882delegation
deleting103314422deleting
delusion937432delusion
demeton1037682demet_on
demotion1169072demotion
depletions1355742depletions
desertion10410202desertion
detection121310412detection
detention10169542detention
devotion1256762devotion
dilation92215462dilation
dilution9239142dilution
elation73620452_elation
election102015352_election
elution72913822_elution
gelation93014432gelation
relation82619772relation
repletion1147692repletion
selection11311272selection
telethon1146002telethon
ablation10312433ablation
ablution1047223ablution
ademption1443493ademption
adulation10311013adulation
aeration8319933aeration
alation72920553_alation
bilection13156803bilection
bolection13117673bolection
chelation1439963chelation
dalton7311273dal_t_on
deaeration11313013deaeration
dealations11311373dealations
deceptions1547863deceptions
decision1148523decision
declension1343513declension
decoction1447523decoction
decurion1146623decurion
deduction1377083deduction
defecation1679803defecation
defections161510203defections
deflations1439713deflations
deflections17187323deflections
deflexions2142563deflexions
dejections20168353dejections
delating103119603delating
delator83015023delat_or
delectation1448553delectation
delegations1348033delegations
deleing93313953dele_ing
delete73620703delet__e
deleted93314913delet_ed
deletes83117933delet_es
delineation1247763delineation
deltic9312503del_ti_c
deltoid938573del_toid
delusions1037053delusions
demetons1137623demet_ons
demolition1376983demolition
demotions1258443demotions
denegation1249413denegation
dentation10315243dentation
dentin73919573de_nti_n
dentition1049633dentition
depiction1437273depiction
depilation13312033depilation
depleting1378193depleting
depletive1545623depletive
derision939073derision
desertions1139883desertions
desolation11311403desolation
detections131410043detections
detentions11148803detentions
detrition1049133detrition
deuteron946003deuteron
devein1039143deve_i_n
deviation13312393deviation
devolution1486283devolution
devotions1356593devotions
diction102313053d_iction
digestion1146573digestion
dilations102614453dilations
dilutions10248583dilutions
diluvion12215413diluvion
direction1289783direction
donation91513783donation
dotation91412733dotation
duration9312693duration
edition8310853_edition
eduction1169053eduction
egestion946863_egestion
ejection172510043_ejection
elations83719123_elations
elections112414973_elections
electron102611413_electron
elevation1239233_elevation
elevon977953_ele_von
elision72311103_elision
elusion72310953_elusion
elutions82513053_elutions
elytron1045463_elytron
emetin8613463_emeti_n
emotion9711303_emotion
enation73419233_enation
erection102115513_erection
evection131910833_evection
exertion15310083_exertion
fellation1238843fellation
fetation11613143fetation
flection13239563flection
flexion1735073_flexion
gelatin83514733gelati_n
gelations102513093gelations
halation11313853halation
hellion10311133hel_lion
ideation9310493ide_ation
illation8311943illation
impletion1345403impletion
lection92614863le_ction
legation92412933legation
legion75712983__legion
lenition8310083lenition
lesion64715063__lesion
lotion65716523__lotion
melton8311553mel_t_on
mention9314373me_ntion
negation92913023negation
oblation1039863oblation
peloton938743pelot_on
peltation11312963peltation
pereion9312053pere_ion
petition10711753petition
prelection141511293prelection
reaction10612603reaction
reception13410323reception
reelection12198633reelection
refection141512283refection
reflation12412333reflation
reflection15168993reflection
reflexion1943613reflexion
rejection181710253rejection
relations92418333relations
relegation11610023relegation
reliction11310693reliction
religion996743religion
remotion10410233remotion
repletions1247473repletions
resection111613273resection
retention91611483retention
secretion11118303secretion
section92515663se_ction
sedation9312453sedation
sedition939333sedition
selections12310873selections
skeleton1244473skelet_on
solation8916153solation
solution889593solution
telethons1246023telethons
venation11513503venation
venetian1146073venetian
vexation1838783vexation
volition1179173volition
volution1198603volution

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.436409841.7
2DLD Change Limit1461621746.76621602.4
3Display Results1741740.0632761.9
 (SQL Overall)1786911747.26524596.1
 
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.