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

141 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
misreads1126892(None) 
misleads11358541misleads
misread10339721misread_
dispreads1346002dispreads
lipreads1144222lipreads
misdeals1147222misdeals
misdeeds12276812misdeeds
miseats92815782mis_eats
misfeeds14315622misfeeds
mishears1338322mishears
mislead10419972mislead_
mispleads1444202mispleads
misseats104011682misseats
missends11368232missends
mistends11419592mistends
mistreats1148632mistreats
airheads1246133airheads
bespreads1443503bespreads
besteads11307113besteads
bigheads15145653bigheads
breads95419203__breads
dispends12308533dispends
dispread1247103dispread_
disregards1352583disregards
disseats93211503disseats
distends10339823distends
dreads84115023__dreads
impleads13294593impleads
inroads837043_inroads
isoleads944373_isoleads
lipread1034953lipread_
mastheads1545243mastheads
meads85425323m___eads
midstreams1542573midstreams
midyears1443403midyears
mihrabs1444203mihr_abs
milreis937323milre_is
minerals10311373minerals
minuends1143893minuends
mired85729223mi_re_d_
mires75640883mi_re__s
mirexes1636993mi_rexes
mirzas1738183mi_rza_s
misadd1037163mis__add
misadds1136303mis_adds
misawards1563793misawards
misbias1139083misbia_s
misbinds1345163misbinds
misbrands1445153misbrands
misclass1246833misclass
miscreant1347563miscreant
miscreants1445083miscreants
miscreate1348893miscreate
miscreates1448103miscreates
misdeal1037663misdea_l
misdealt1147973misdealt
misdeed113211053misdeed_
misdeems13255653misdeems
misdials1137493misdials
misdraws1445753misdraws
misease92713043mis_ease
miseases102614343mis_eases
miseat82925703mis_ea_t
misereres1148183misereres
miseries10320403miseries
misers85025703mis_e_rs
mises74740563mis_e__s
misfed124113023misfe_d_
misfeed13389683misfeed_
misfields15223653misfields
misgrade1247503misgrade
misgrades1347363misgrades
mishaps1438713mis_haps
mishear1238393mishea_r
misheard1446253misheard
mishegaas1562193mishegaas
miskals13369763mis_kals
miskeeps1644163miskeeps
mislays12349243mis_lays
misleader1246503misleader
misleaders1345203misleaders
mislearn1045343mislearn
mislearns1144523mislearns
misled94719313misle_d_
mismade12129353mis_made
mismeets12297733mismeets
mispens11311073mispe_ns
misplans1238863misplans
misplays1555543misplays
misplead1345023misplead_
misraise10410523misr_aise
misrate91319143misr_ate
misrates101318243misrates
misreading1448263misreading
misrecords1552913misrecords
misrefer1346103misrefer
misrefers1445363misrefers
misrelate1147933misrelate
misrelates1247623misrelates
misrelies1149723misrelies
misrely12319613misre_ly
misrender1286293misrender
misrenders1375353misrenders
misrules1039383misrules
missals93914423mis_sals
missays124010253mis_says
misseat93617233missea_t
missed94423603misse_d_
missels94614813misse_ls
missend104411373missend_
misses85130873misse__s
missets94516573misse_ts
misspeaks1743063misspeaks
misspends1443853misspends
misteach1545443misteach
misted93625823miste_d_
mistend103812523mistend_
misterms123711353misterms
misters93927513miste_rs
mistrals101212623mistrals
mistreat10313113mistrea_t
mistress10310703mistre_ss
mistrials1148133mistrials
miswords1446603miswords
mitred94414343mitre_d_
mitres83922073mitre__s
myriads1334353m_yriads
oreads73915773__oreads
outreads9289003outreads
pinheads14336243pinheads
pitheads14338143pitheads
reads64835273___reads
rereads81512293_rereads
respreads1244523respreads
retreads937823retreads
spreads1039763_spreads
steads74116223__steads
threads11419953_threads
treads74817923__treads
untreads936223untreads
wiseass1035823wis_eass

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.1731032896.0
2DLD Change Limit1461621416.95321021.4
3Display Results1411410.0632238.1
 (SQL Overall)1786911417.18924856.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.