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

211 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
nictate931022(None) 
dictate10311661dictate
nictated1137791nictated
nictates1039591nictates
bistate9313822bistate
dictated1239202dictated
dictates11311382dictates
instate71616482instate
lactate9312692lactate
nictitate1145402nictitate
nidate7313782ni_date
niobate937702niobate
nitrate72017012nitrate
notate63217862n_otate
nutate63017372n_utate
pectate112214692pectate
picrate112014142picrate
vittate10409732vittate
acetate92514753acetate
actuate9311443_actuate
acuate8315633_acuate
agitate8312063agitate
airdate8311323airdate
animate91617213ani_mate
annotate877713annotate
antistate9410143antistate
arcuate9311963arcuate
aristate8312133aristate
baccate131011263baccate
binate8419773bi_nate
biotite9311033biotite
cate66254603__c_ate
cicale10314503cic_ale
ciliate9514603ciliate
cirrate92413493cirrate
citrate92216803citrate
costate94019273costate
crate76537403__crate
cristate10310603cristate
curtate9312643curtate
dentate8315153dentate
dicta84915633dicta__
dictator1147263dictator
digitate1098683digitate
diktat11310693diktat_
diktats1235623diktats
dilatate947773dilatate
dilate73220693di_late
disrate81418523disrate
distaste939943distaste
eructate1047333eructate
estate64719763_estate
fictile1238023fictile
fictive1537023fictive
filiate10414233filiate
filtrate1148223filtrate
fissate103010033fissate
fixate1638733fi_xate
gestate83614073gestate
guttate8328903guttate
hastate10313913hastate
hectare1238463hectare
ideate7313683_ideate
imitate9310873imitate
incage93513623inc_age
incase83615283inc_ase
inchoate1347673inchoate
incite83618733inc_ite
increate10312203increate
incubate1238663incubate
incudate1138873incudate
indicate11313353indic_ate
inflate10312313inflate
ingate73018243_ingate
ingrate8715123ingrate
initiate8412693initiate
inmate82917363_inmate
innate63917313_innate
instated91613343instated
instates81615833instates
intake10510863_intake
iodate7313503_iodate
irate55627983_i_rate
lactase937953lactase
lactated1138863lactated
lactates10311223lactates
librate93214233librate
licente91210893licente
liftgate1243413liftgate
ligate72519253li_gate
limbate1139213limbate
lineate7815153lineate
liquate1638423liquate
locate83919843loc_ate
metate82720533_metate
micturate1366643micturate
migrate101314173migrate
militate10311673militate
ministate1147263ministate
mintage101110123mintage
misate81222693mi_sate
misdate101413963misdate
mismate111415353mismate
misrate91319143misrate
misstate10711343misstate
mistake131312623mistake
mutate83017483_mutate
narrate7313493narrate
nectar838853necta_r
nectars938463nectars
nectary1246223nectary
negate72915573n_egate
neonate7311333neonate
nervate1039523nervate
nicad8312613nic_a_d
nicads938333nic_ads
nice65534713nic___e
nicest82315663nicest_
nicety1138433nic_ety
niche105016793nic__he
nickle123814483nic_kle
nickname1642793nickname
nicoise937923nicoise
nicotine1058473nicotine
nictating1237573nictating
nictation1189273nictation
nictitated1344403nictitated
nictitates1244953nictitates
nidated939863ni_dated
nidates8311893ni_dates
niobates1037283niobates
niobite937953niobite
nitchie1247233nitchie
nite45943583ni___te
nitrated92213153nitrated
nitrates82516223nitrates
nitre57519683ni_t_re
nitrite72314463nitrite
nitty85418313ni_t_ty
nizamate1943533nizamate
noctule936083noctule
notated82713663n_otated
notates72817483n_otates
noviciate1444423noviciate
nuchae11218513nucha_e
nucleate1048673nucleate
nutated83113423n_utated
nutates73214973n_utates
nutcase975763nutcase
octane81411633_octane
octave11157343_octave
outate62923403_outate
pectase112410363pectase
pectates122213953pectates
peltate92013773peltate
picante11310523picante
piccata1345703piccata
pickaxe2244623pickaxe
picrated132110113picrated
picrates122013213picrates
picrite111911313picrite
picture1158613picture
pileate93815923pileate
pinnate93613743pinnate
pirate82322883pi_rate
plicate11314513plic_ate
punctate1246473punctate
recrate92621663recrate
redictate1249063redictate
restate73824883restate
rictal83113183ricta_l
rotate63320343_rotate
saccate111311763saccate
sanitate8612043sani_tate
scutate9310323scutate
septate9511873septate
sigmate10710143sigmate
sinuate7412163sinuate
situate7410783situate
sonicate10310933sonic_ate
spectate12248833spectate
spicate113214193spic_ate
state56237333__state
tate44748603___tate
tectite9310583tectite
testate73916233testate
tictac1036563ticta_c
tictacs1145793tictacs
titrate72215573titrate
toccate1138773toccate
tractate10411003tractate
tristate8311033tristate
tunicate103310043tunic_ate
uintaite8127353uintaite
uncinate10312393uncinate
uncrate9415953uncrate
unitage838993uni_tage
unstate71916213unstate
upstate91610493upstate
vacate11314553vac_ate
vibrate122811523vibrate
vicarate1378603vicarate
vicomte1445723vicomte
vintage11128143vintage
violate10311553violate
virgate1138733virgate
vitae84217633vi_ta_e
vitiate103412953vitiate
vittae93911003vitta_e
wickape1843723wickape
zincate1838533zincate

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272116.44020811.6
3Display Results2112110.0762776.3
 (SQL Overall)1786912116.92225814.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.