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

200 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
dictates1131138(None) 
dictate10311661dictate_
dictated1239201dictated
nictates1039591nictates
dictator1147262dictator
dictators1247362dictators
diktats1235622diktat_s
dilates83220662di_lates
disrates91118152disrates
distastes1039632distastes
distaves12311402distaves
lactates10311222lactates
nictate9310222nictate_
nictated1137792nictated
pectates122213952pectates
picrates122013212picrates
redictates1348232redictates
abdicates1448153abdic_ates
acetates102013063acetates
actuates10310313_actuates
agitates9310883agitates
airdates939723airdates
biotites10310083biotites
bistate9313823bistate_
cates75951893__c_ates
ciliates10413453ciliates
citrates102315093citrates
crates85736063__crates
dacites101114593dac_ites
dates65639153d___ates
dealates92716683dealates
debates103718533d_ebates
decades113615513dec_ades
decanes103118913dec_anes
decares102818533dec_ares
deceases11410153deceases
deciares11510633deciares
decimates14410693decimates
declares11611313declares
decorates12314743decorates
dedicates13311693dedic_ates
deflates123013943deflates
delates83526283d_elates
delectates1348193delectates
delicates12314313delic_ates
dentate8315153dentate_
dentated10411703dentated
derates84028893d_erates
desiccates1545383desiccates
deviates12312733deviates
diabases1137223diabases
diabetes1147023diabetes
diaconates1346703diaconates
diamantes1296263diamantes
diastases1047073diastases
dicasts1078703dic_asts
dices86434243dic___es
dickies143416343dic_kies
dicots94915793dic_ot_s
dicta84915633dicta___
dictating1338883dictating
dictation12810563dictation
dictations1389703dictations
dictier103411863dict_ier
dictiest113212783dict_iest
dictions111812673dictions
dictums1235553dict_ums
dietaries10410663dietaries
digitate1098683digitate_
digitated1286963digitated
diktat11310693diktat__
dilatate947773dilatate_
dilate73220693di_late_
dilated93115823di_lated
dilater83515653di_later
dilaters92513063di_laters
dilutes82911973di_lutes
dinettes9310193dinettes
dioptases1245903dioptases
diorites9313523diorites
dioxanes1645373dioxanes
dipsades1246493dipsades
diquats1745983diquat_s
dirties83119383dirt_ies
discases112014503discases
diseases92415813diseases
disputes1139653disputes
disrate81418523disrate_
disrated10915573disrated
dissaves1239413dissaves
distaffs1565083distaffs
distains9413603distains
distances12311653distances
distaste939943distaste_
distasted1137963distasted
distomes11314163distomes
ditas65923673di_ta__s
ditches133215713di_tches
dites66339153di___tes
dittanies1045733dittanies
ditties83116983di_tties
dittos74111973di_t_tos
ditzes163212423di_t_zes
divagates1444733divagates
dockages1635983dockages
doctorates1346203doctorates
donates83217223d_onates
dotages92311793d_otages
driftages1453153driftages
ducats95011763duc_at_s
ductules1155543ductules
ectases92911673_ectases
edentates1046953edentates
educates1139623educ_ates
eructates1146953eructates
estates74520183_estates
filiates11412663filiates
filtrates1247733filtrates
fixates1737393fi_xates
gestates93213733gestates
hectares1338853hectares
ictuses938303_ictuses
ideates8313733_ideates
imitates10310503imitates
indicates12312583indic_ates
ingates82716913_ingates
inmates92715783_inmates
instates81615833instates
intakes11310943_intakes
iodates8312903_iodates
lactases1038513lactases
lactate9312693lactate_
lactated1138863lactated
librates103412953librates
liftgates1343513liftgates
ligates82318383li_gates
liquates1737453liquates
litotes7311183li_totes
locates93218813loc_ates
medicates14312113medic_ates
meditates1239813medi_tates
metates92720013_metates
micturates1456093micturates
migrates111112853migrates
militates11310883militates
mintages111110513mintages
misdates111113633misdates
mismates121114563mismates
misrates101318243misrates
misstates11710633misstates
mistakes141213413mistakes
mutates92215793_mutates
nictitates1244953nictitates
nidates8311893ni_dates
niobates1037283niobates
nitrates82516223nitrates
notates72817483_notates
nutates73214973_nutates
octanes91111393_octanes
octaves12316963_octaves
pectases122411193pectases
pectate112214693pectate_
pickaxes2344913pickaxes
picrate112014143picrate_
picrated132110113picrated
picrites121811083picrites
pictures1249343pictures
pirates93020333pi_rates
radicates12412073radic_ates
recrates102420373recrates
redictate1249063redictate_
redictated1447483redictated
restates83423433restates
rictuses1037563rictuses
rotates72819773_rotates
sinuates8310963sinuates
situates8310373situates
spectates13228813spectates
states64337083__states
tates55444983___tates
tectites1039993tectites
testates83615453testates
tictacs1145793ticta_cs
titrates82314663titrates
tractates1159763tractates
uintaites9136333uintaites
uncrates10314563uncrates
unstates81314993unstates
upstates10189643upstates
vacates12312833vac_ates
vibrates132210613vibrates
vicarates1487623vicarates
vicomtes1545593vicomtes
vintages12118273vintages
violates11311193violates
virgates1237923virgates
vitiates112311433vitiates
vittate10409733vittate_
wickapes1943703wickapes
zincates1937743zincates

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622006.31023163.5
3Display Results2002000.0802500.0
 (SQL Overall)1786912006.81326227.9
 
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.