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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
decoction144752(None) 
decoctions1547141decoctions
deception1448322deception
decocting1538122decocting
decoctive1745862decoctive
decoration13314422decoration
deduction1377082deduction
defection151610642defection
dejection19178662dejection
demotion1169072demo_tion
depiction1437272depiction
detection121310412detection
devotion1256762devo_tion
coaction12310773__coaction
coition9314313__coition
concoction1348233concoction
dealation10313003dealation
deceptions1547863deceptions
decillion1245833decillion
decimation15411623decimation
decision1148523dec_ision
decoct11313783decoct___
decocted1437693decoct_ed
decocts1237833decoct__s
decollation1448193decollation
decondition1545413decondition
decontrol1243783decontrol
decorations14312883decorations
decryption1843743decryption
decurion1146623dec_urion
dedication14311963dedication
deductions1467133deductions
defecation1679803defecation
defections161510203defections
deflation13310653deflation
deflection16147733deflection
dejections20168353dejections
delation92318083de_lation
deletion92011973de_letion
demolition1376983demolition
demotions1258443demo_tions
denotation11311083denotation
dentation10315243dentation
dentition1049633dentition
depictions1546893depictions
depletion1256663depletion
deposition13107833deposition
derogation12410393derogation
desertion10410203desertion
desolation11311403desolation
desorption1346223desorption
detections131410043detections
detention10169543detention
detonation11310943detonation
detraction13138583detraction
detrition1049133detrition
deviation13312393deviation
devolution1486283devolution
devotions1356593devo_tions
dictation12810563dictation
diction102313053d__iction
direction1289783direction
eduction1169053_eduction
ejection172510043_ejection
election102015353_election
elocution1145673_elocution
emotion9711303_emo_tion
erection102115513_erection
evection131910833_evection
eviction13228683_eviction
evocation142010293_evocation
exaction1738953_exaction
lection92614863le__ction
reaction10612603re_action
recaution1148093recaution
reception13410333reception
redaction1259663redaction
reduction1259903reduction
refection141512283refection
rejection181710253rejection
reliction11310693reliction
relocation12312113relocation
remotion10410233remo_tion
resection111613273resection
retortion949673retortion
revocation15410813revocation
secretion11118303secretion
section92515663se__ction
seduction1266983seduction
selection11311273selection

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 Filter1786911486410.420425454.8
2DLD Change Limit148641906.73322076.5
3Display Results90900.0332727.3
 (SQL Overall)178691907.18624866.5
 
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.