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

320 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
mishits12251308(None) 
misfits12279661misfits
mishit112618201mishit_
dipshits1445262dipshits
mashies12318252mashies
midships1645692midships
mights123516252migh_ts
misacts1139352misacts
misaims11310112misaims
misbias1139082misbias
miscite11314382miscite
miscites12313782miscites
miscuts1139182miscuts
miseats92815782miseats
misedits1147962misedits
misfit112813832misfit_
mishaps1438722mishaps
mislies92922282mislies
mislit83019692mislit_
missets94516572missets
missies93423982missies
missis84417502missi_s
missuits1078022missuits
mists76633902mis__ts
muskits13278562muskits
rishis9312452rishi_s
shits84731172__shits
visits9311422vis_its
airships1347713airships
airshots1145943airshots
amidships1743693amidships
arshins10312573arshins
bights124417963bigh_ts
binits85716673bi_nits
biscuits1245133biscuits
bisects1137133bisects
bishops1437033bishops
bushtits1343533bushtits
chits105424573__chits
cissies94116153cissies
cists76624533cis__ts
cushats12288273cushats
dashis104414393dashi_s
dights114016963digh_ts
digits84114533di_gits
dimwits1344513dimwits
dipshit1347993dipshit_
disherits1348233disherits
dishes104622653dish_es
dishier113613403dishier
dishiest12313683dishiest
dishing124017103dishing
dismiss1038153dismiss
distils83015803distils
dixits144210313di_xits
eights103618983eigh_ts
fights133816553figh_ts
fishers134714723fishers
fishes125221343fish_es
fishgigs1642093fishgigs
fishier13359853fishier
fishiest14310453fishiest
fishily1637643fishily
fishing143913863fishing
fishings15307693fishings
fishnets1445633fishnets
fists85527543fis__ts
gists66026193gis__ts
hights133716893high_ts
hissies103915823hissies
hists86328373his__ts
hits75545133___hits
islets64513083_islets
jesuits1436323jesuits
kinships1745793kinships
kishkas1343483kishkas
kishkes1334773kishkes
kismats13257843kismats
kismets13306883kismets
kists95822113kis__ts
lashins103915153lashins
lichis115212593lichi_s
lichts113712383lich_ts
lights104519913ligh_ts
limits82514143li_mits
lists56628693lis__ts
lithias1038823lithias
maists85817573mais__ts
mascots113910343mascots
mashers124621053mashers
mashes115030003mash_es
mashie11315933mashi_e
mashing134422243mashing
masjids17175403masjids
massifs1237743massifs
mastics112614783mastics
mastitis1039103mastitis
masts77035763mas__ts
megahits1445683megahits
menhirs1235913menhirs
mephitis1546113mephitis
merits8320873m_erits
meshes115019443mesh_es
meshier123410853meshier
meshiest132911033meshiest
meshing134513813meshing
mesquits19496483mesquits
miches134320733mich_es
miching152911803miching
midairs1037203midairs
middies113116153middies
midgets113910253midgets
midguts11296013midguts
midis85923413mi_di_s
midlist10312513midlist
midlists1137523midlists
midribs1235513midribs
midship1546043midshi_p
midsts95510053mi_dsts
might113827083migh_t_
mighty154310213migh_ty
millets94216843millets
milts75430713mi__lts
mimics1289363mi_mics
minims104514813mi_nims
minis75432993mi_ni_s
minnies93617363minnies
mints76834043mi__nts
minuets9259853minuets
miosis83615163miosi_s
miotics112710653miotics
mirins83918903mi_rins
misact10316693misact_
misadds1136303misadds
misaim10311853misai_m
misate81222693mis_ate
misbill1137033misbill
misbills1246083misbills
misbind1258273misbind
misbinds1345163misbinds
miscast11312423miscast
miscasts1238353miscasts
mischief1846423mischief
mischiefs1943063mischiefs
miscited13310423miscited
miscoins12311083miscoins
miscues11312393miscues
miscut10614823miscut_
misdate101413963misdate
misdates111113633misdates
misdial1039643misdial
misdials1137493misdials
misdid10510573misdi_d
misdoes10312493misdoes
miseat82925713miseat_
misedit10311043misedit_
miseries10320403miseries
misers85025703mis_ers
mises74740563mis__es
misfaith1644543misfaith
misfaiths1742463misfaiths
misfile122611553misfile
misfiles133110983misfiles
misfire12229893misfire
misfires132210583misfires
misgive13339033misgive
misgives14329293misgives
mishap1338873mish_ap
mishear1238393mishear
mishears1338323mishears
mishmash18133433mishmash
mishmosh18112913mishmosh
misjoins1736913misjoins
miskals13369763miskals
miskick1435613miskick
miskicks1544763miskicks
mislays12349243mislays
mislie83219153misli_e
mislights1544663mislights
mislike132914833mislike
mislikes143311833mislikes
mislive122812693mislive
mislives132912153mislives
mismate111415353mismate
mismates121114563mismates
mismeets12297733mismeets
mismet103722373mismet_
misos76523293mis__os
mispaints13106183mispaints
misparts12108173misparts
mispens11311073mispens
mispoints13106633mispoints
misprints13107223misprints
misrate91319143misrate
misrates101318243misrates
miss65339423mis___s
missals93914423missals
missays124010253missays
misseats104011683misseats
missels94614813missels
misses85130873mis_ses
misset85028153misset_
missile92815403missile
missiles103015083missiles
missing103619073missing
mission9312743mission
missions10311903missions
missises103513693missises
missive122413143missive
missives133212843missives
missorts1038323missorts
missouts1037623missouts
missuit9911303missuit_
missus85312293mis_sus
mist66154533mis__t_
misters93927513misters
misthink1745433misthink
misthinks1843353misthinks
mistier93418713mistier
mistiest103018313mistiest
mistily122612343mistily
mistime11312613mistime
mistimes12612613mistimes
misting103623383misting
mistitle1038523mistitle
mistitles1147953mistitles
misty106120453mis__ty
misuses93216023misuses
miswrit1249413miswrit_
miswrite1348923miswrite
miswrites1447983miswrites
mithers123516733mithers
mitis75425993mi_ti_s
mitts75523753mi__tts
mosaics1138073mosaics
moshers124017843moshers
moshes115222873mosh_es
moshing134214883moshing
moshings14367333moshings
mosts76028543mos__ts
muscats1138933muscats
muscids12187973muscids
mushers124016443mushers
mushes114124563mush_es
mushier123813593mushier
mushiest133212873mushiest
mushily152410093mushily
mushing134217633mushing
musics103911783mus_ics
musjids17185713musjids
muskets13258643muskets
muskies133614673muskies
muskit122813253muskit_
muslins9312213muslins
musts75527443mus__ts
muzhiks2573093muzhiks
mysids1246563mys_ids
mysosts1234543mysosts
mystics14279103mystics
nights104117723nigh_ts
nihils937573ni_hils
niseis63512023nisei_s
nitwits1035053nitwits
outhits102213503outhits
pipits104713063pi_pits
pishers123815753pishers
pishes114722103pish_es
pishing134314373pishing
pistils93314303pistils
posits85718713pos_its
reships1239863reships
resits64725563res_its
rights104019333righ_ts
rimshots1343883rimshots
rishi8311253rishi__
roshis9311793roshi_s
shies86136553__shies
shifts124412943__shifts
shims104422553__shims
shins85131043__shins
ships105123773__ships
shirts94918343__shirts
shist84829613__shist
shists96515113__shists
shit76745943__shit_
shivs115018803__shivs
shots84730853__shots
shuts85622483__shuts
sights103818013sigh_ts
siskins1159583siskins
sissies73716603sissies
sits45050203__s_its
skits94721863__skits
slits56128853__slits
smithies1337913smithies
snits54124833__snits
spits74429553__spits
suits55028053__suits
sushis9311183sushi_s
tidbits1035183tidbits
tights104015853tigh_ts
titbits935803titbits
tushies10312163tushies
unshifts1444033unshifts
unships1237203unships
upshifts1642633upshifts
upshots1235193upshots
vichies15310623vichies
visit8320963vis_it_
weskits1434743weskits
whishts16425313whish_ts
whits115923823__whits
wights133315783wigh_ts
wisents10249063wisents
wishers133215213wishers
wishes124920953wish_es
wishing144114893wishing
wists86728523wis__ts
withies133913543withies
withins133511693withins

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 Limit1340273205.79623124.1
3Display Results3203200.1262539.7
 (SQL Overall)1786913206.32828238.1
 
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.