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

227 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
mishaps143872(None) 
mishap1338871mishap_
bishops1437032bishops
midships1645692midships
miseats92815792miseats
mishears1338322mishears
mishits122513082mishits
miskals13369772miskals
mislays12349242mislays
missals93914432missals
missays124010252missays
misshape1545982misshape
misshapes1645912misshapes
airships1347713airships
amidships1743693amidships
bashaws15347713bashaws
bishop1336943bishop_
bitmaps1344253bitmaps
cashaws15398573cashaws
chaps125326063__chaps
cushats12288273cushats
cushaws15356293cushaws
dirhams13376313dirhams
disbars10310323disbars
dishes104622653dish_es
dishpan13105523dishpan
dishpans14115833dishpans
dishrags1346203dishrags
dismals102010243dismals
dismays13237433dismays
fiscals1238003fiscals
fishers134714723fishers
fishes125221343fish_es
fishways2043643fishways
geishas1135083geisha_s
haps96443463___haps
isbas71010403_isba_s
jihads1734483ji_hads
kashas133311903kasha_s
kidnaps1453323kidnaps
kinships1745793kinships
kishkas1343483kishkas
kishkes1334773kishkes
kismats13257843kismats
lisps76913913lis__ps
lithops12307253lithops
madcaps1435243madcaps
maps86141053m___aps
marshals1337783marshals
masas75630413mas_a_s
mashers124621053mashers
mashes115030003mash_es
mashies12318253mashies
massas85116463massa_s
mayhap1635233mayhap_
mesas76823203mes_a_s
mescals112911573mescals
meshes115019443mesh_es
messans92710463messans
miasmas1167743miasma_s
micas96823053mi_ca_s
miches134320733mich_es
midcap1336473midcap_
middays14335663middays
midship1546043midship_
midways16386183midways
mights123516253migh_ts
mihrabs1444203mihrabs
mikvahs19162493mikvahs
milpas101710273milpa_s
mimbars1397383mimbars
minas75434113mi_na_s
minyans1237263minyans
mips85534083mi___ps
mirzas1738183mirza_s
misact10316693mis_act
misacts1139353misacts
misadapt1345203misadapt
misadapts1442833misadapts
misadd1037163mis_add
misadds1136303misadds
misaim10311853mis_aim
misaims11310113misaims
misate81222693mis_ate
misbias1139083misbias
miscall1139653miscall
miscalls1239003miscalls
miscast11312423miscast
miscasts1238353miscasts
misclass1246843misclass
miscopy1636663miscopy
miscues11312393miscues
miscuts1139183miscuts
misdate101413963misdate
misdates111113633misdates
misdeals1147233misdeals
misdials1137503misdials
misdoes10312493misdoes
misdraws1445753misdraws
misease92713043misease
miseases102614343miseases
miseat82925713misea_t
misers85025703mis_ers
mises74740563mis__es
misfits12279663misfits
misgave13298283misgave
mishear1238393mishear
misheard1446253misheard
mishegaas1562193mishegaas
mishit112618203mish_it
mishmash18133433mishmash
mishmosh18112913mishmosh
miskal123710263miska_l
miskeeps1644163miskeeps
miskept1538923miskept
mislaid1039303mislaid
mislain9311243mislain
mislay113510683misla_y
misleads11358543misleads
mislies92922283mislies
mismade12129353mismade
mismake15139373mismake
mismakes16129883mismakes
mismark1536703mismark
mismarks1645893mismarks
mismate111415353mismate
mismates121114563mismates
misname11119483misname
misnames12119883misnames
misos76523293mis__os
mispage12310523mispage
mispages13311183mispages
misparse1237733misparse
mispart111113783mispart
misparts12108173misparts
mispens11311073mispens
misplans1238863misplans
misplays1555543misplays
misraise10410523misraise
misrate91319143misrate
misrates101318243misrates
misreads11268923misreads
miss65339423mis___s
missaid10310303missaid
missal84314903missa_l
missay114112143missa_y
misseats104011683misseats
missels94614813missels
misses85130873mis_ses
missets94516573missets
misshaped1744753misshaped
misshapen1643783misshapen
misshaper1644403misshaper
misshapers1743403misshapers
missies93423983missies
missis84417503mis_sis
misstamps1543373misstamps
missteps12156143missteps
misstops12176413misstops
missus85312293mis_sus
mistake131312623mistake
mistakes141213413mistakes
misters93927513misters
mistrals101212633mistrals
mists76633903mis__ts
mistype14126523mistype
mistypes15116713mistypes
misuses93216023misuses
mithers123516733mithers
mitsvahs1642003mitsvahs
mixups1743263mi_xups
mobcaps1543463mobcaps
mochas13310663mocha_s
moshav1446053mosha_v
moshers124017843moshers
moshes115222873mosh_es
mudcaps1444103mudcaps
mughals1355763mughals
muscats1138933muscats
mushers124016443mushers
mushes114124563mush_es
orishas1036473orisha_s
pashas115117063pasha_s
perhaps1446123perhaps
pishers123815753pishers
pishes114722103pish_es
pshaws14435703_pshaws
pushups1433653pushups
reshape1249043reshape
reshapes1338803reshapes
reships1239863reships
rikshaws1852653rikshaws
ripraps1134943ripraps
rishis9312453rish_is
saps65346373__s_aps
sashays1336333sashays
shads95124483__shads
shags95123863__shags
shahs115919513__shahs
shams105829413__shams
shape105125113__shape
shapes115124953__shapes
sharps115516083__sharps
shaws116226263__shaws
shays116021433__shays
ships105123773__ships
shnaps1148083__shnaps
shops104222903__shops
sisals63013573sis_als
slaps76025713__slaps
smashups1543213smashups
snaps74719563__snaps
soaps75120713__soaps
swaps104819203__swaps
trishaws1444003trishaws
unships1237203unships
unsnaps935423unsnaps
visas84317653vis_a_s
vistas94513273vista_s
visuals1036863visuals
washups1534683washups
whaps135115163__whaps
wiseass1035823wiseass
wisha114910853wisha__
wishers133215213wishers
wishes124920953wish_es
wisps105214183wis__ps

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 Limit1340272275.94022563.5
3Display Results2272270.0932440.9
 (SQL Overall)1786912276.43927751.4
 
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.