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

163 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
nictates103959(None) 
dictates11311381dictates
nictate9310221nictate_
nictated1137791nictated
dictate10311662dictate_
dictated1239202dictated
instates81615832instates
lactates10311222lactates
nictitates1244952nictitates
nidates8311892ni_dates
niobates1037282niobates
nitrates82516222nitrates
notates72817482n_otates
nutates73214972n_utates
pectates122213952pectates
picrates122013212picrates
acetates102013063acetates
actuates10310313_actuates
agitates9310883agitates
airdates939723airdates
animates101316423ani_mates
annotates977293annotates
biotites10310083biotites
bistate9313823bistate_
cates75951893__c_ates
ciliates10413453ciliates
citrates102315093citrates
crates85736063__crates
dictator1147263dictator
dictators1247363dictators
diktats1235623diktat_s
dilates83220663di_lates
disrates91118153disrates
distastes1039633distastes
distaves12311403distaves
ectases92911673_ectases
eructates1146953eructates
estates74520183_estates
filiates11412663filiates
filtrates1247733filtrates
fixates1737393fi_xates
gestates93213733gestates
hectares1338853hectares
ictuses938303_ictuses
ideates8313733_ideates
imitates10310503imitates
incages103013883inc_ages
incases93615973inc_ases
incites93218483inc_ites
incubates1347603incubates
indicates12312583indic_ates
inflates11512193inflates
ingates82716913_ingates
ingrates9514173ingrates
initiates9411183initiates
inmates92715783_inmates
instate71616483instate_
instated91613343instated
intakes11310943_intakes
iodates8312903_iodates
lactases1038513lactases
lactate9312693lactate_
lactated1138863lactated
librates103412953librates
liftgates1343513liftgates
ligates82318383li_gates
liquates1737453liquates
litotes7311183li_totes
locates93218813loc_ates
metates92720013_metates
micturates1456093micturates
migrates111112853migrates
militates11310883militates
ministates1246743ministates
mintages111110513mintages
misdates111113633misdates
mismates121114563mismates
misrates101318243misrates
misstates11710633misstates
mistakes141213413mistakes
mutates92215793_mutates
narrates8312763narrates
nates55238333n___ates
nectaries1149813nectaries
nectars938463necta_rs
negates83215843n_egates
neonates8310063neonates
nicads938333nic_a_ds
niceties10310863niceties
niches114419143nic__hes
nickles133713823nic_kles
nicknames1742753nicknames
nicotines1148353nicotines
nictating1237573nictating
nictation1189273nictation
nictations1278313nictations
nictitate1145403nictitate_
nictitated1344403nictitated
nidate7313783ni_date_
nidated939863ni_dated
nifties102612503nift_ies
niobate937703niobate_
niobites1037313niobites
nitchies1339073nitchies
nites55736343ni___tes
nitrate72017013nitrate_
nitrated92213153nitrated
nitres65519333ni_t_res
nitrites82313453nitrites
nizamates2043273nizamates
noctules1036583noctules
nontaxes1537853nontaxes
notate63217863n_otate_
notated82713663n_otated
noviciates1543763noviciates
nucleates1148563nucleates
nutate63017373n_utate_
nutated83113423n_utated
nutcases1085793nutcases
octanes91111393_octanes
octaves12316963_octaves
pectases122411193pectases
pectate112214693pectate_
pickaxes2344913pickaxes
picrate112014143picrate_
picrated132110113picrated
picrites121811083picrites
pictures1249343pictures
pirates93020333pi_rates
recrates102420373recrates
redictates1348233redictates
restates83423433restates
rictuses1037563rictuses
rotates72819773_rotates
sanitates9611733sani_tates
sinuates8310963sinuates
situates8310373situates
sonicates11410383sonic_ates
spectates13228813spectates
states64337083__states
tates55444983___tates
tectites1039993tectites
testates83615453testates
tictacs1145793ticta_cs
titrates82314663titrates
tractates1159763tractates
tunicates11268743tunic_ates
uintaites9136333uintaites
uncrates10314563uncrates
unitages938273uni_tages
unstates81314993unstates
upstates10189643upstates
vacates12312833vac_ates
vibrates132210613vibrates
vicarates1487623vicarates
vicomtes1545593vicomtes
vintages12118273vintages
violates11311193violates
virgates1237923virgates
vitiates112311433vitiates
vittate10409733vittate_
wickapes1943703wickapes
zincates1937743zincates

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.420425454.8
2DLD Change Limit1461621637.20320291.8
3Display Results1631630.0632587.3
 (SQL Overall)1786911637.68623248.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.