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

171 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
misadds113630(None) 
misadd1037161misadd_
mikados1444682mikados
miladis1049822miladis
misacts1139352misacts
misadded1335752misadded
misaims11310112misaims
visards11328152visards
adds67622453___adds
camisades1474963camisades
camisados1472563camisados
cicadas1235993cicadas
desands94810163desands
dipsades1246493dipsades
disarms1039043disarms
disbands1237353disbands
disbuds11125243disbuds
discards1238913discards
guisards1043603guisards
irades74517393_irades
islands837323_islands
jihads1734483jiha_ds
liards75212613li_ards
ligands9438983ligands
lizards17427613lizards
mads76845373m__a_ds
maids86327143m__aids
mansards1148013mansards
marauds1037553marauds
masalas9312053masalas
masas75630413masa__s
masjids17175403masjids
mauds85519273m__auds
mazards1937703mazards
meads85425323m_ea_ds
menads95514383mena_ds
mesas76823203mesa__s
miaous8511693mi_aous
miaows1145473mi_aows
miasmas1167743miasmas
miasms1097383mi_asms
miauls8178713mi_auls
micas96823053mica__s
midairs1037203midairs
middays14335663middays
middy124812593mi__ddy
midis85923413mi__dis
midlands1245543midlands
mids76541793mi___ds
mikado1344513mika_do
miladi938883mila_di
miladies1139923miladies
milady1236613mila_dy
milages103114403milages
milds86422053mi__lds
milords10117853milords
minas75434113mina__s
minds85427123mi__nds
mirador1046503mirador
miradors1146853miradors
mirages102213533mirages
misact10316693misa_ct
misadapt1345203misadapt
misadapts1442833misadapts
misadding14115833misadding
misaddress1451523misaddress
misadjust1952123misadjust
misadvise1542933misadvise
misaim10311853misa_im
misally121111063misally
misandry1443863misandry
misate81222693misa_te
misaver1249813misaver
misavers1348063misavers
misawards1563793misawards
misbias1139083misbias
misbinds1345163misbinds
misbrands1445153misbrands
miscalls1239003miscalls
miscasts1238353miscasts
miscode12310413miscode
miscodes13310423miscodes
miscues11312393miscues
miscuts1139183miscuts
misdate101413963misdate
misdates111113633misdates
misdeeds12276813misdeeds
misdid10510573mis_did
misdo85413183mis__do
misdoes10312493misdoes
miseases102614343miseases
miseats92815793miseats
misedit10311043misedit
misedits1147963misedits
misers85025703mis_ers
mises74740563mis__es
misfed124113023misfed_
misfeeds14315623misfeeds
misfits12279663misfits
misgrades1347363misgrades
mishaps1438723mishaps
mishits122513083mishits
miskals13369773miskals
mislaid1039303mislaid_
mislays12349243mislays
misleads11358543misleads
misled94719313misled_
mislies92922283mislies
mismade12129353mismade
mismakes16129883mismakes
mismarks1645893mismarks
mismates121114563mismates
misnames12119883misnames
misos76523293mis__os
mispages13311183mispages
misparts12108173misparts
mispens11311073mispens
misrates101318243misrates
misreads11268923misreads
miss65339423mis___s
missaid10310303missaid_
missals93914433missals
missays124010253missays
missed94423603missed_
missels94614813missels
missends11368233missends
misses85130873mis_ses
missets94516573missets
missies93423983missies
missis84417503mis_sis
missus85312293mis_sus
mistakes141213413mistakes
misted93625823misted_
mistends11419593mistends
misters93927513misters
mists76633903mis__ts
misuses93216023misuses
miswords1446603miswords
monades103713823monades
monads94515303mona_ds
mosaics1138073mosaics
muscids12187973muscids
musjids17185713musjids
mustards11297883mustards
mysids1246563mys_ids
nicads938333nica_ds
outadds936203outadds
pesades10310903pesades
posadas1037193posadas
readds84111643_readds
ribalds10236673ribalds
ribands10208393ribands
ritards8439943ritards
sades65239893__sades
sadis64930853__sadis
saids65328853__saids
sands65228583__sands
sards64736183__sards
sisals63013573sisa_ls
sudds75513593__sudds
tirades8311723tirades
tisanes7311853tisanes
tsades74310993_tsades
tsadis7429133_tsadis
viands1047813vi_ands
visaed104110503visaed_
visages1138693visages
visard103910123visard_
visas84317653visa__s
vizards20377263vizards
wizards20326403wizards

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271717.04619021.7
3Display Results1711710.0802137.5
 (SQL Overall)1786911717.54623680.2
 
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.