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

153 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
misteuk133589(None) 
misted93625822miste_d
mistend103812522mistend
mister84728562miste_r
misterm114314512misterm
misters93927512misters
mistook1337152mistook
bister84922763biste_r
bisters93922613bisters
cisted95217523ciste_d
cistern93310703cistern
cistus84611343cist_us
diseur738843dis_eur
distend93312073distend
distent84120853distent
fisted104218703fiste_d
fistful1365903fistful
histed104420243histe_d
kistful1465303kistful
listed74322833liste_d
listee64223063liste_e
listees73416673listees
listel64214743liste_l
listels74212433listels
listen64816813liste_n
listens74014133listens
lister64527253liste_r
listers74026533listers
masseur935703masseur
masted94025803maste_d
master84831343maste_r
masters94628923masters
mastery124214323mastery
meister93114163meiste_r
meisters103313843meisters
mestee84523883meste_e
mestees94617753mestees
mesteso937133mesteso
midterm12316013midterm
midweek1743273midweek
milieu8314113milieu_
milieus939803milieus
milieux1643783milieux
milted93919943milte_d
milter84921233milte_r
milters93619093milters
minster93914323minste_r
minsters103813923minsters
minted94220583minte_d
minter84425103minte_r
minters93822473minters
misate81222693misate__
misbegun1342423misbegun
miscook1546473miscook
miscue10412223mis_cue
miscued1239293miscued
miscues11312393miscues
miscut10614823mis_cut
misdeal1037663misdeal
misdeed113211053misdeed
misdeem12217873misdeem
mise66043593mis_e__
miseat82925713mis_eat
miser75430403mis_e_r
misers85025703mis_ers
misery114113543mis_ery
mises74740563mis_e_s
misfed124113023misfe_d
misfeed13389683misfeed
mishear1238393mishear
miskeep1536403miskeep
miskept1538923miskept
miskick1435613miskick
mislead10419973mislead
misled94719313misle_d
mismark1536703mismark
mismeet113215163mismeet
mismet103722373misme_t
mispen10312173mispe_n
mispens11311073mispens
misread10339723misread
misrely12319613misrely
misseat93617243misseat
missed94423603misse_d
missel85216523misse_l
missels94614813missels
missend104411373missend
missent94318713missent
misses85130873misse_s
misset85028153misse_t
missets94516573missets
missout9412663missout
misspeak1643493misspeak
missteer1037223missteer
misstep11158463misste_p
missteps12156143missteps
misstruck1762523misstruck
missus85312293mis_sus
mist66154543mist___
mistake131312623mistake
mistbow1443993mistbow
misteach1545443misteach
mistends11419593mistends
misterms123711353misterms
misthink1745433misthink
mistier93418713mistier
mistiest103018313mistiest
mistily122612343mistily
mistime11312613mistime
misting103623383misting
mistouch1543803mistouch
mistral91013643mistral
mistreat10313113mistreat
mistress10310703mistress
mistrust1049203mistrust
mistruth1346043mistruth
mists76633903mist__s
mistune9310653mistune
misty106120453mist__y
mistype14126523mistype
mite66249423mi_te__
miter75734793mi_te_r
miters84328783mi_ters
mites75141803mi_te_s
mitten83914093mitte_n
mittens9349883mittens
moisten93110143moiste_n
moistens10268773moistens
moister94015373moiste_r
moistest1038763moistest
moistful1343853moistful
moste75925083moste__
mostest9314793mostest
muktuk1142883mukt_uk
museum1037703mus_eum
musted93321073muste_d
mustee83922103muste_e
mustees94614923mustees
muster84724523muste_r
musters94522513musters
mystery15436523mystery
pasteup1134983pasteup
piste75824603piste__
pistes85325633piste_s
pistou83211843pistou_
pistous92714383pistous
sister64421583siste_r
sisters73721593sisters
sistrum946563sistrum
steak95219803__steak
steek95418003__steek
wisted104120273wiste_d
wistful1365713wistful

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.423422437.4
2DLD Change Limit1340271536.32621186.7
3Display Results1531530.0632428.6
 (SQL Overall)1786911536.81226231.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.