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

129 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
dictation1281056(None) 
dictations1389701dictations
nictation1189271nictation
citation10314362ci_tation
dentation10315242dentation
dictating1338882dictating
dictator1147262dictat_or
diction102313052dic__tion
dilatation1147392dilatation
dilation92215462di_lation
dotation91412732d_otation
jactation1838142jactation
lactation11310812lactation
nictations1278312nictations
siltation939212siltation
abdication1548223abdic_ation
actuation11310333_actuation
adaptation1355223adaptation
agitation10311223agitation
arcuation11410583arcuation
cation83925503__c_ation
ciliation111112493ciliation
citations11312503ci_tations
cunctation1476913cunctation
damnation1238403damnation
darnation1039823darnation
dealation10313003dealation
decantation1448943decantation
deception1448323deception
decimation15411623decimation
decoction1447523decoction
decoration13314423decoration
dedication14311963dedic_ation
deflation13310653deflation
delation92318083d_elation
delectation1448553delectation
denotation11311083denotation
dentations11413633dentations
dentition1049633dentition
deputation1339393deputation
desiccation1646383desiccation
deviation13312393deviation
diatron839283di__atron
dictate10311663dictat__e
dictated1239203dictat_ed
dictates11311383dictat_es
dictators1247363dictators
dictions111812673dic__tions
dietitian1043763dietitian
digestion1146573digestion
dilatations1246413dilatations
dilations102614453di_lations
dilution9239143di_lution
direction1289783direction
discretion1347523discretion
disputation14116743disputation
distain8313783dista_i_n
distention11158873distention
distortion1146693distortion
distraction1449113distraction
divagation15104373divagation
divination14139233divination
donation91513783d_onation
dotations101411633d_otations
dubitation1377333dubitation
duration9312693d_uration
education12310203educ_ation
elicitation1347533elicitation
eructation1248333eructation
excitation19410173excitation
fetation11613143_fetation
fiction122010733fic__tion
filiation121110243filiation
filtration1346433filtration
fixation1837073fi_xation
flirtation1354823flirtation
flotation1267813flotation
gestation10310663gestation
gustation1047963gustation
guttation1046173guttation
himation1339753hi_mation
ideation9310493_ideation
illation8311943_illation
imitation11510853imitation
incitation12312223incitation
indication13312033indic_ation
iodation9310383_iodation
jactations1936893jactations
lactations1239423lactations
libation102411363li_bation
libration111510163libration
ligation92313093li_gation
limitation1249153limitation
lineation9310763lineation
liquation1846553liquation
location102113913loc_ation
medication15411173medic_ation
meditation13410743medi_tation
mentation11313983mentation
migration12179703migration
miscitation1547773miscitation
mutation101412883_mutation
natation81513933_natation
nictating1237573nictating
nidation9410583ni_dation
nitration9313443nitration
notation81414603_notation
nutation81513103_nutation
peltation11312963peltation
pinnation1138013pinnation
plication13311683plic_ation
potation101716783_potation
punctation1486053punctation
quotation18146973quotation
recitation12315943recitation
restation9316913restation
rotation81615453_rotation
saltation9312003saltation
siltations1038553siltations
sinuation9310413sinuation
situation949423situation
station72717243__station
titration9310543titration
vacation131911893vac_ation
vibration14138203vibration
violation1238443violation
visitation1348593visitation
vitiation1239563vitiation
vocation132311983voc_ation

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 Filter1786911486410.643277902.0
2DLD Change Limit1486411298.86016776.6
3Display Results1291290.0602150.0
 (SQL Overall)1786911299.56318685.7
 
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.