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

424 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
nidates831189(None) 
nidate7313781nidate_
nidated939861nidated
airdates939722airdates
animates101316422animates
dates65639152__dates
dilates83220662dilates
fixates1737392fixates
ideates8313732_ideates
indites83618982indites
ingates82716912ingates
inmates92715782inmates
iodates8312902iodates
ligates82318382ligates
misdates111113632misdates
nates55238332n__ates
negates83215842negates
nictates1039592nictates
nides65229132nid__es
nidgets9358142nidgets
niduses837012niduses
niobates1037282niobates
nites55736342ni__tes
nitrates82516222nitrates
notates72817482notates
nutates73214972nutates
oxidates1636332oxidates
pirates93020332pirates
redates83423872redates
sedates83418032sedates
updates10329792updates
abates85825033_abates
ablates92416903ablates
adages8412953_adages
addaxes1634573addaxes
aerates74627493aerates
agates76121343_agates
agitates9310883agitates
agnates82813193agnates
aides65336603aid__es
airdate8311323airdate_
alates64833963_alates
alidades1037003alidades
amidases1136653amidases
amirates101114793amirates
andantes9310853andantes
animate91617213animate_
animated111612373animated
animater101512393animater
animaters11129973animaters
annates72415423annates
antedates1048613antedates
antidotes1049533antidotes
ates45047923___ates
aviates10313063aviates
bates75846343__bates
bedmates1349183bedmates
berates94126863berates
biases84618433bi_ases
biddies113514493biddies
bides85536773bid__es
bidets95215533bidet_s
bifaces1448063bifaces
binate8419773binate_
bites75641173bi__tes
borates94823013borates
candidates1446303candidates
carates95630613carates
cates75951883__cates
caudates11310263caudates
cerates95428253cerates
ciliates10413453ciliates
cites74435593ci__tes
citrates102315093citrates
climates12311973climates
cnidae978143cnida_e_
comates114123643comates
crates85736063_crates
creates95225193creates
curates95323833curates
daces85030683__daces
dales66439743__dales
dames85435853__dames
dares66146703__dares
date56443323__date_
dated75530993__dated
dater65332313__dater
daters74827373__daters
datos65222783__datos
dazes155024143__dazes
debates103718533debates
delates83526283delates
denudates1145583denudates
derates84028893derates
dictates11311383dictates
didacts1186063didacts
diddles103915073diddles
didies84621833did_ies
didoes85716963did_oes
dilate73220693dilate_
dilated93115823dilated
dilater83515653dilater
dilaters92513063dilaters
dilutes82911973dilutes
disrates91118153disrates
dites66339153__dites
donates83217223donates
dotes65836693__dotes
elates65032363_elates
eluates72014683eluates
emirates101214853emirates
enates64026423_enates
endites83717063endites
epidotes1147023epidotes
epilates10313503epilates
equates162012323equates
ergates8314493ergates
estates74520183estates
exudates1636623exudates
fates85139233__fates
fiats85324483fi_at_s
fiddles123212603fiddles
fidges114114383fid_ges
fidgets12388763fidgets
filiates11412663filiates
finales104016013finales
finites10315923finites
fixate1638733fixate_
fixated1835533fixated
folates103218453folates
frigates12310933frigates
gates65939513__gates
gelates83219583gelates
giddies103713363giddies
gites65630183gi__tes
gradates10510783gradates
grates75429893_grates
gyrates113610263gyrates
hamates122917683hamates
hates86742573__hates
hiatus938223hi_atus
hides95129423hid__es
humates122813193humates
hydrates15229403hydrates
ideate7313683_ideate_
ideated9310973_ideated
ides57734233_id__es
idles66720123_id_les
ikats95311153_ikat_s
images91411463_images
imitates10310503imitates
inanes62519803_inanes
incages103013883incages
incases93615973incases
incites93218483incites
indabas1045853indabas
indagates1146573indagates
indenes82916253indenes
indexes15339453indexes
indicates12312583indicates
indices103513443indices
indies73822783ind_ies
indite73520323indite_
indited93515023indited
inditer83514233inditer
inditers93311053inditers
indoles83716363indoles
induces103611813induces
indues73515263ind_ues
indurates10310693indurates
infantes11249633infantes
infares10313023infares
inflates11512193inflates
ingate73018243ingate_
ingrates9514173ingrates
inhales10511863inhales
initiates9411183initiates
inlaces92512903inlaces
inmate82917363inmate_
innages82911303innages
innate63917313innate_
instates81615833instates
intakes11310943intakes
intimates111013313intimates
inundates1045773inundates
invades11118293invades
invites103915813invites
iodate7313503iodate_
iodated9310023iodated
irades74517393_irades
irate55627983_irate_
irater65218353_irater
iratest7312483_iratest
judases1534443judases
karates115617473karates
kiddies133412283kiddies
kiddoes13387063kiddoes
kinases113511123kinases
kites95432543ki__tes
lapidates1247143lapidates
legates82917683legates
lianes63819323li_anes
librates103412953librates
lidars7310783lida_rs
ligases82310713ligases
ligate72519253ligate_
ligated92414143ligated
limites92915453limites
linages8813173linages
lindanes939173lindanes
lipases9209483lipases
liquates1737453liquates
litotes7311183litotes
locates93218813locates
luxates1436973luxates
lysates10317473lysates
madames12310063madames
malates93522603malates
mandates11314093mandates
mates75251363__mates
mediates112814063mediates
metates92720013metates
midairs1037203midairs
middies113116153middies
middles113415303middles
midges103516473mid_ges
midgets113910253midgets
midsts95510053midst_s
migrates111112853migrates
milages103114403milages
minutes93513443minutes
mirages102213533mirages
misate81222693misate_
misdate101413963misdate_
misdated121211123misdated
mismates121114563mismates
misrates101318243misrates
mites75141803mi__tes
mutates92215793mutates
nabes75427093n__abes
nadas66320813nada__s
naiades838213naiades
naivetes1145113naivetes
names74833363n__ames
napes74828463n__apes
nares55544153n__ares
narrates8312763narrates
naves87030383n__aves
navigates1345873navigates
neaten64214543n_eaten
neatens73310403n_eatens
neater64424313n_eater
neatest72516003n_eatest
neats55931903n_eat_s
neddies92710703neddies
negate72915573negate_
negated93413233negated
negater83711963negater
negaters9349783negaters
neonates8310063neonates
nibbles114011693nibbles
nicads938333nica_ds
niceties10310863niceties
niches114419143ni_ches
nickles133713823nickles
nictate9310223nictate_
nictated1137793nictated
nidal65217103nida__l
nidating1039783nidating
nidation9410583nidation
nidations1039213nidations
nide55535783nid__e_
nided75920873nid__ed
nidget83715633nid_get
nidifies1238233nidifies
nidus65913573nid__us
nieces84112713ni_eces
nieves94311293ni_eves
nifties102612503nifties
niggles93512203niggles
nighties121011383nighties
nights104117723night_s
nines55937343ni__nes
nineties8312913nineties
ninnies73713613ninnies
ninths936933ni_nths
niobate937703niobate_
niobites1037313niobites
nipas77116673nipa__s
nipples11319663nipples
nite45943583ni__te_
niter55028973ni__ter
niters64624213ni__ters
nitrate72017013nitrate_
nitrated92213153nitrated
nitres65519333ni_tres
nitrites82313453nitrites
nits45741643ni__t_s
nixes124519623ni__xes
nixies135313873ni_xies
nizamates2043273nizamates
nizams1735413niza_ms
noddies93512043noddies
noddles92911293noddles
nodes64633493nod__es
nodules8269703nodules
nominates11311053nominates
nonages8313843nonages
nopales93812523nopales
norites74018803norites
notate63217863notate_
notated82713663notated
notes55034583n__otes
noyades1136563noyades
nudes64723293nud__es
nudges84114733nud_ges
nudies75217093nud_ies
nudities939683nudities
nudzhes2032523nudzhes
nutate63017373nutate_
nutated83113423nutated
oblates91913243oblates
oleates7417833oleates
opiates9312143opiates
orates64328613_orates
outdates93114743outdates
oxidases1643883oxidases
oxidate1537023oxidate_
oxidated1745033oxidated
palates93624933palates
pates76047893__pates
pedate93117763pedate_
penates93321593penates
picrates122013213picrates
piddles114314273piddles
pikakes1245823pikakes
pinatas93711503pinatas
pinites9319533pinites
pipages1289423pipages
pirate82322883pirate_
pirated102515613pirated
pistes85325633pi_stes
plates85432243_plates
podites103014733podites
prates84633163_prates
predates11615813predates
primates121515933primates
privates131812373privates
pupates113311433pupates
radiates92415293radiates
rates55352013__rates
rebates95123183rebates
redate74124683redate_
redated93120923redated
relates73731433relates
remates93827113remates
riatas63915093ri_atas
riddles93215023riddles
rides66140813rid__es
ridges85817003rid_ges
rites54442553ri__tes
rivages1138873rivages
rotates72819773rotates
ruinates8311883ruinates
sanitates9611733sanitates
sates54949323__sates
savates10312953savates
sedate73019803sedate_
sedated93714343sedated
sedater83713623sedater
sedatest9249393sedatest
senates73322583senates
sides65838363sid__es
sidles74721153sid_les
silages82514443silages
silanes72517163silanes
sinuates8310963sinuates
sites56045433si__tes
situates8310373situates
sixtes133612403si_xtes
skates104219393_skates
slates64934063_slates
solates73523853solates
sonicates11410383sonicates
spates85028173_spates
states64337083_states
tates55444983__tates
tides64830153tid__es
tidies74721833tid_ies
tirades8311723tirades
tisanes7311853tisanes
titrates82314663titrates
tunicates11268743tunicates
uncrates10314553uncrates
undated93118463undated
unifaces1346393unifaces
unitages938273unitages
unites65024853uni__tes
unstates81314993unstates
update93810293update_
updated11369423updated
updater10347253updater
updaters11255183updaters
uprates93814863uprates
urates65027763_urates
urinates8314133urinates
vacates12312833vacates
validates1338243validates
vanadates1345133vanadates
vibrates132210613vibrates
videttes1266333videttes
violates11311193violates
virgates1237923virgates
visages1138693visages
vitiates112311433vitiates
vivaces1536413vivaces
widdies123514033widdies
widdles123514343widdles
wides94832823wid__es
widgets12318453widgets
widths1335123wid_ths
windages1338263windages
wites85536963wi__tes
zincates1937743zincates

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340274248.86015127.2
3Display Results4244240.1562717.9
 (SQL Overall)1786914249.15619516.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.