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

271 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
mishap133886(None) 
mishaps1438711mishaps
bishop1336942bishop
mayhap1635232mayhap
midcap1336472midcap
midship1546042midship
miseat82925702miseat
mishear1238392mishear
mishit112618192mishit
miskal123710262miskal
mislay113510682mislay
missal84314902missal
missay114112142missay
misshape1545972misshape
moshav1446052moshav
wisha114910852wisha_
airship1248513airship
amidship1644303amidship
bashaw14349303bashaw
bishops1437033bishops
bitmap1235613bitmap
cashaw14439793cashaw
chap114928493__chap
cushat113513693cushat
cushaw14386983cushaw
dirham12378273dirham
disbar938513disbar
dish86328333dish__
dished114318713dished
dishes104622653dishes
dishpan13105523dishpan
dishrag1246273dishrag
dishy125712353dish_y
dismal92412243dismal
dismay12229473dismay
distal73615773distal
fiscal1139333fiscal
fish106926273fish__
fished134316313fished
fisher124917143fisher
fishes125221343fishes
fishway1943813fishway
fishy146011663fish_y
geisha1035203geisha_
geishas1135073geishas
giddap1143413giddap
hap87360053___hap
isba61310883_isba_
isbas71010403_isbas
jihad1635913ji_had
kasha124710723kasha_
kashas133311903kashas
kidnap1334193kidnap
kinship1645823kinship
kishka1232963kishka
kishkas1343483kishkas
kishke1254273kishke
kismat123011673kismat
lisp68926883lis__p
madcap1336333madcap
map77255123m___ap
marshal1238973marshal
masa65034723mas_a_
masas75630413mas_as
mash96039403mash__
mashed125325043mashed
masher114123203masher
mashes115030003mashes
mashie11315933mashie
mashy136016503mash_y
massa75518923massa_
massas85116463massas
mesa67025483mes_a_
mesas76823203mes_as
mescal104113483mescal
mesh96823003mesh__
meshed124415933meshed
meshes115019443meshes
meshy135612783mesh_y
mesial84818083mesial
mesian84315503mesian
messan83912063messan
miasma1097563miasma_
miasmal1176743miasmal
miasmas1167743miasmas
mica86428253mi_ca_
micas96823053mi_cas
miche126219243mich_e
miched143913393miched
miches134320733miches
micra96214973micra_
midday13327503midday
midships1645693midships
midway15327153midway
might113827083migh_t
mights123516253mights
mighty154310203mighty
mihrab1335523mihrab
mikra114610313mikra_
mikvah18143473mikvah
milia72719573milia_
milpa92111403milpa_
milpas101710273milpas
mimbar1297493mimbar
mina65136923mi_na_
minae75627723mi_nae
minas75434113mi_nas
minyan1138173minyan
mirza16410443mirza_
mirzas1738183mirzas
mis58162623mis___
misact10316683misact
misadapt1345193misadapt
misadd1037163misadd
misaim10311853misaim
misate81222693misate
misbias1139083misbias
miscall1139643miscall
miscast11312413miscast
miscopy1636663miscopy
miscue10412223miscue
miscut10614813miscut
misdate101413963misdate
misdeal1037663misdeal
misdial1039643misdial
misdid10510573misdid
misdo85413183mis_do
misdraw1345623misdraw
mise66043583mis__e
misease92713043misease
miseats92815783miseats
miser75430403mis_er
misers85025703misers
misery114113543misery
mises74740563mis_es
misfed124113023misfed
misfit112813833misfit
misgave13298283misgave
misheard1446253misheard
mishears1338323mishears
mishits122513083mishits
mishmash18133433mishmash
miskals13369763miskals
miskeep1536403miskeep
miskept1538923miskept
mislaid1039303mislaid
mislain9311243mislain
mislays12349243mislays
mislead10419973mislead
misled94719313misled
mislie83219153mislie
mislit83019693mislit
mismade12129353mismade
mismake15139373mismake
mismark1536703mismark
mismate111415353mismate
mismet103722373mismet
misname11119483misname
miso67229903mis__o
misos76523293mis_os
mispage12310523mispage
mispart111113773mispart
mispen10312173mispen
misplan1147773misplan
misplay1436383misplay
misrate91319143misrate
misread10339723misread
miss65339423mis__s
missaid10310303missaid
missals93914423missals
missays124010253missays
misseat93617233misseat
missed94423603missed
missel85216523missel
misses85130873misses
misset85028153misset
misshaped1744753misshaped
misshapen1643783misshapen
misshaper1644403misshaper
misshapes1645913misshapes
misshod1335873misshod
missis84417503missis
misstamp1443803misstamp
misstep11158463misstep
misstop11156413misstop
missus85312293missus
missy105617563mis_sy
mist66154533mis__t
mistake131312623mistake
misted93625823misted
mister84728563mister
mistral91013643mistral
mists76633903mis_ts
misty106120453mis_ty
mistype14126523mistype
misuse83213643misuse
mither114218563mither
mitral81314323mitral
mitsvah1542163mitsvah
mixup1636773mi_xup
mobcap1444113mobcap
mocha1249923mocha_
mochas13310663mochas
mosh95227603mosh__
moshed124517493moshed
mosher114719793mosher
moshes115222873moshes
mudcap1335133mudcap
mughal1236273mughal
musca9311763musca_
muscae10410673muscae
muscat10314653muscat
mush94929123mush__
mushed124420843mushed
musher113820573musher
mushes114124563mushes
mushy135316633mush_y
orisha936773orisha_
orishas1036473orishas
pasha105417183pasha_
pashas115117063pashas
pish96127913pish__
pished124817063pished
pisher114317753pisher
pishes114722103pishes
poisha1135723poisha_
pshaw13447513_pshaw
pushup1335273pushup
reshape1249043reshape
reship11310673reship
rikshaw1762873rikshaw
riprap1055513riprap
rishi8311253rish_i
rishis9312453rishis
sap56463233__s_ap
sashay1238363sashay
sha69837783__sha_
shad86230913__shad
shag86430563__shag
shah105627783__shah
sham96436363__sham
shape105125113__shape
sharp104922533__sharp
shat76456603__shat
shaw108132553__shaw
shay107133343__shay
ship95228243__ship
shop95629843__shop
sisal54217733sis_al
slap66434043__slap
smashup1443453smashup
snap65727033__snap
soap65831133__soap
swap95925433__swap
trishaw1344753trishaw
unsharp1235543unsharp
unship1148033unship
unsnap836203unsnap
visa76323873vis_a_
visas84317653vis_as
vista85416603vista_
vistas94513273vistas
visual938803visual
washup1435323washup
whap125119643__whap
wish107228733wish__
wished134417513wished
wisher123617063wisher
wishes124920953wishes
wisp97124073wis__p
withal1238933withal

Search took 6 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 Filter1786911127160.1231452772.4
2DLD Change Limit1127162715.65619928.6
3Display Results2712710.0932914.0
 (SQL Overall)1786912715.87230431.0
 
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.