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

173 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
deletions10261093(None) 
delations102616591delations
deletion92011971deletion_
depletions1355741depletions
dealations11311372dealations
deceptions1547862deceptions
defections161510202defections
deflations1439712deflations
deflections17187322deflections
deflexions2142562deflexions
dejections20168352dejections
delation92318082delation_
delegations1348032delegations
deleting103314422deleti_ng
delusions1037052delusions
demetons1137622demet_ons
demotions1258442demotions
depletion1256662depletion_
desertions1139882desertions
detections131410042detections
detentions11148802detentions
devotions1356592devotions
dilations102614452dilations
dilutions10248582dilutions
elations83719122_elations
elections112414972_elections
elutions82513052_elutions
gelations102513092gelations
relations92418332relations
repletions1247472repletions
selections12310872selections
telethons1246022telethons
ablations11311513ablations
ablutions1146603ablutions
ademptions1543383ademptions
adulations11310123adulations
aerations9317903aerations
alations82518893_alations
bilections14136503bilections
bolections14137293bolections
chelations1539073chelations
daltons8310403dal_t_ons
deaerations12311673deaerations
dealation10313003dealation_
deception1448323deception_
decisions1248383decisions
declensions1443333declensions
decoctions1547143decoctions
decurions1246023decurions
deductions1467133deductions
defecations1779003defecations
defection151610643defection_
deflation13310653deflation_
deflection16147733deflection_
deflexion2042823deflexion_
dejection19178663dejection_
delating103119603delati_ng
delators92314823delat_ors
delectations1547453delectations
delegation1238883delegation_
deleing93313953dele_i_ng
deleterious1252113deleterious
deletes83117933delet__es
delicious1246713delicious
delineations1346763delineations
delirious1045603delirious
deltoids1045483del_toids
delusion937433delusion_
demeton1037683demet_on_
demolitions1446523demolitions
demotion1169073demotion_
denegations1348543denegations
dentations11413633dentations
dentins83419223de_nti_ns
dentitions1148853dentitions
depictions1546893depictions
depilations14310903depilations
depleting1378193depleti_ng
derisions1038843derisions
desertion10410203desertion_
desolations12310593desolations
detection121310413detection_
detention10169543detention_
detritions1148953detritions
deuterons1046783deuterons
deveins1138803deve_i_ns
deviations14311163deviations
devolutions15106263devolutions
devotion1256763devotion_
dictions111812673d_ictions
digestions1246403digestions
dilation92215463dilation_
dilution9239143dilution_
diluvions13224443diluvions
directions1379643directions
donations101112353donations
dotations101411633dotations
durations10311463durations
editions9310403_editions
eductions1268773eductions
egestions1046703_egestions
ejections18249963_ejections
elation73620453_elation_
election102015353_election_
electrons112411753_electrons
elevations1338633_elevations
elevons1067573_ele_vons
elisions82210423_elisions
elusions82610083_elusions
elution72913823_elution_
emetins9812643_emeti_ns
emotions10610283_emotions
enations83316903_enations
erections112515213_erections
evections142510693_evections
exertions1639763_exertions
fellations1338063fellations
fetations12511383fetations
flections14239213flections
flexions1844413_flexions
gelatins93414093gelati_ns
gelation93014433gelation_
halations12312393halations
hellions11310023hel_lions
ideations1039903ide_ations
illations9311393illations
impletions1445003impletions
lections102413843le_ctions
legations102711923legations
legions84611783__legions
lenitions939473lenitions
lesions73813873__lesions
lotions74614763__lotions
meltons9410923mel_t_ons
mentions10312893me_ntions
negations102811963negations
oblations1139373oblations
pelotons1038913pelot_ons
peltations12311553peltations
pereions10310853pere_ions
petitions11511083petitions
prelections151210473prelections
reactions11711713reactions
receptions1449743receptions
reelections13167943reelections
refections151811643refections
reflations13311233reflations
reflections16178553reflections
reflexions2043303reflexions
rejections191510103rejections
relation82619773relation_
relegations1248973relegations
relictions12310023relictions
religions1086603religions
remotions1149703remotions
repletion1147693repletion_
resections121513033resections
retentions101611113retentions
secretions12117853secretions
sections102714703se_ctions
sedations10311253sedations
seditions1039013seditions
selection11311273selection_
selenious946963selenious
skeletons1343933skelet_ons
solations9814623solations
solutions988883solutions
telethon1145993telethon_
venations12311723venations
venetians1244673venetians
vexations1937753vexations
volitions1288663volitions
volutions12108393volutions

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411736.47022973.9
3Display Results1731730.0762276.3
 (SQL Overall)1786911736.96925640.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.