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

266 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
mislays1234924(None) 
mislay113510681mislay_
misplays1555541misplays
missays124010251missays
dismays13237432dismays
displays1446292displays
inlays9389872_inlays
middays14335662middays
midways16386182midways
misclass1246842misclass
miseats92815782miseats
mishaps1438722mishaps
miskals13369762miskals
mislaid1039302mislaid
mislain9311242mislain
mislayer1337502mislayer
mislayers1445942mislayers
misleads11358542misleads
mislies92922282mislies
misplans1238862misplans
misplay1436382misplay_
missals93914422missals
missay114112142missay_
slays85723682__slays
airplays1344533airplays
airways1336243airways
aisles64721143aisl_es
aisleways1542103aisleways
allays94313743_allays
assays977903_assays
belays114313853_belays
bialys11387913bial_ys
byplays1743103byplays
clays105521333__clays
cullays12347703cullays
delays104014053_delays
disbars10310323disbars
dismals102010243dismals
dismay12229473dismay_
display1336663display_
essays965653_essays
fiscals1238003fiscals
fishways2043643fishways
flays116321053__flays
inlay85214323_inlay_
isbas71010403_isba_s
island738533_island
islands837323_islands
isles54220563_isl_es
islets64513083_islets
kiblahs1634153kiblahs
kiblas1239323kibla_s
kismats13257843kismats
lays76043253___lays
liblabs1144123liblabs
lilacs837483li_lacs
lisles63416283lisl_es
mainstays1443393mainstays
malars85020683m_alars
margays1337493margays
masalas9312053masalas
masas75630413mas_a_s
massas85116463massa_s
maydays1634493maydays
mays96940033m___ays
medlars10259443medlars
medleys13115333medleys
mesas76823203mes_a_s
mescals112911563mescals
messans92710463messans
miasmas1167743miasma_s
micas96823053mi_ca_s
mickeys18447943mickeys
midday13327503midday_
midland1136613midland
midlands1245543midlands
midlegs1156323midlegs
midway15327153midway_
mihrabs1444203mihrabs
mikvahs19162493mikvahs
miladi938883mi_ladi
miladis1049823mi_ladis
milady1236613mi_lady
milage93414123mi_lage
milages103114403mi_lages
milds86422053mi_l_ds
milers84625163mi_lers
miles74645073mi_l_es
milks115020583mi_l_ks
milky144014443mi_lky_
millage103112753millage
millages113212903millages
milldams1344633milldams
millers93621343millers
milles84526563mi_lles
millets94216843millets
mills75435053mi_l_ls
milos75428013mi_l_os
milpas101710273mi_lpas
mils66045333mi_l__s
milts75430713mi_l_ts
milty104720073mi_lty_
mimbars1397383mimbars
minas75434113mi_na_s
minilabs12124573minilabs
minyans1237263minyans
mirzas1738183mirza_s
misact10316693mis_act
misacts1139353misacts
misadd1037163mis_add
misadds1136303misadds
misaim10311853mis_aim
misaims11310113misaims
misally121111063misally
misassays1442533misassays
misate81222693mis_ate
misbias1139083misbias
miscall1139653miscall
miscalls1239003miscalls
miscast11312423miscast
miscasts1238353miscasts
misclaim1445063misclaim
misclaims1544593misclaims
miscues11312393miscues
miscuts1139183miscuts
misdate101413963misdate
misdates111113633misdates
misdeals1147223misdeals
misdials1137493misdials
misdoes10312493misdoes
misdraws1445753misdraws
misease92713043misease
miseases102614343miseases
miseat82925713misea_t
misers85025703mis_ers
misery114113543misery_
mises74740563mis__es
misfits12279663misfits
misgave13298283misgave
mishap1338873misha_p
mishears1338323mishears
mishits122513083mishits
miskal123710263miska_l
mislabel1296173mislabel
mislabels13114313mislabels
mislabor1244503mislabor
mislabors1344513mislabors
mislaying1557913mislaying
mislead10419973mislead
mislearn1045343mislearn
mislearns1144523mislearns
misled94719313misl_ed
mislie83219153misl_ie
mislike132914833mislike
mislikes143311833mislikes
mislit83019693misl_it
mislive122812693mislive
mislives132912153mislives
mismade12129353mismade
mismake15139373mismake
mismakes16129883mismakes
mismark1536703mismark
mismarks1645893mismarks
mismate111415353mismate
mismates121114563mismates
misname11119483misname
misnames12119883misnames
misos76523293mis__os
mispage12310523mispage
mispages13311183mispages
misparse1237733misparse
mispart111113783mispart
misparts12108173misparts
mispens11311073mispens
misplace1437553misplace
misplaces1537953misplaces
misplan1147773mispla_n
misplant12410763misplant
misplants1347313misplants
misplayed1745303misplayed
mispleads1444203mispleads
misraise10410523misraise
misrate91319143misrate
misrates101318243misrates
misreads11268923misreads
miss65339423mis___s
missaid10310303missaid
missal84314903missa_l
misseats104011683misseats
missels94614813missels
misses85130873mis_ses
missets94516573missets
missies93423983missies
missis84417503mis_sis
missus85312293mis_sus
missy105617563mis_sy_
mistake131312623mistake
mistakes141213413mistakes
misters93927513misters
mistrals101212623mistrals
mistryst1345843mistryst
mists76633903mis__ts
misty106120453mis_ty_
misuses93216023misuses
mitsvahs1642003mitsvahs
molars85517323m_olars
molas75132093m_ola_s
mollahs12328283mollahs
moolahs12347383moolahs
moolas83615593moola_s
mooleys1236863mooleys
morays114613883m_orays
moseys114711703mos_eys
motleys1235683motleys
muleys11409643m_uleys
mullahs12388733mullahs
mullas84215933mulla_s
mulleys12299203mulleys
muscats1138933muscats
muslins9312213muslins
mylars114310443m_ylars
oilways1334873oilways
onlays9398713_onlays
outlays102610903outlays
paisleys1333343paisleys
parlays123910453parlays
pilafs113511023pi_lafs
pilaus84114133pi_laus
pilaws11399433pi_laws
pillars9313493pillars
plays106320773__plays
pusleys12286233pusleys
relays94316753_relays
replays12399763replays
resays93714153res_ays
ridleys11145783ridleys
sashays1336333sashays
says75942103__s_ays
shays116021433__shays
sisals63013573sis_als
slabs75322643__slabs
slags66525903__slags
slams74927903__slams
slaps76025713__slaps
slats55436903__slats
slaws85222713__slaws
slay76436383__slay_
smileys12336323smi_leys
spays105520513__spays
splays114910873_splays
stays86022023__stays
sways115518463__sways
teslas64212173tesla_s
tilaks1097353ti_laks
unlays93810493_unlays
unsays9399543uns_ays
villas96117263villa_s
violas93713523viola_s
virelays1444643virelays
visas84317653vis_a_s
vistas94513273vista_s
visuals1036853visuals
vizslas1943143vizsla_s
waylays1634673waylays
wiseass1035823wiseass
zillahs1935383zillahs

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.390458182.1
2DLD Change Limit1340272666.15621771.8
3Display Results2662660.0932860.2
 (SQL Overall)1786912666.63926915.3
 
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.