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

246 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
misseat9361724(None) 
disseat83816921disseat
miseat82925711mi_seat
misseats104011681misseats
missent94318711missent
misset85028151misse_t
disseats93211502disseats
dissect103614132dissect
dissent84018682dissent
dissert83720692dissert
misdeal1037662misdeal
misdealt1147982misdealt
miseats92815792mi_seats
mishear1238392mishear
miskept1538922miskept
mislead10419972mislead
mismeet113215162mismeet
mismet103722372misme_t
misread10339722misread
missal84314902miss_al
missay114112142miss_ay
misseated12610112misseated
missed94423602misse_d
missel85216522misse_l
missels94614812missels
missend104411372missend
misses85130872misse_s
missets94516572missets
missort9314652missort
missout9412662missout
misspeak1643492misspeak
misspelt1247272misspelt
misspent1259172misspent
misstart10410042misstart
misstate10711342misstate
missuit9911302missuit
mistreat10313112mistreat
assent65119953_assent
assert64922583_assert
asset55932263_asse_t
basset85225383basse_t
bassett94213863bassett
bisect10312873bi_sect
cosset84125863cosse_t
dessert82916453dessert
discept12310623discept
disject17268673disject
disseated11711083disseated
dissects11279243dissects
dissed85220183disse_d
dissents93411863dissents
disserts92411813disserts
disses75225963disse_s
distent84120853distent
fissate103010033fiss_ate
gusset7316433gusse_t
hissed104114453hisse_d
hisself1335913hisself
hisser94713793hisse_r
hissers104112313hissers
hisses94719353hisse_s
hissiest112911093hissiest
inseam8329993_inseam
insect83916583_insect
insert64325253_insert
inset54430863_inse_t
islet54527553_isle_t
issei568573_isse_i
isseis638563_isseis
issuant748263_issuant
kismat123011673ki_smat
kismet123414623kisme_t
kissed114412853kisse_d
kisser104212453kisse_r
kissers114211293kissers
kisses104217333kisse_s
massa75518923mass_a_
massas85116463mass_as
masse75125293masse__
massed94421323masse_d
masses85028713masse_s
masseur935703masseur
massiest103314423massiest
meat66359603m___eat
messan83912063mess_an
messed95018183messe_d
messes84924343messe_s
messiah1246793messiah
messiest103112423messiest
messman1137283messman
messmate1246393messmate
miasma1097563miasma_
miasmal1176743miasmal
miasmas1167743miasmas
miasmata1244503miasmata
midget103718453midge_t
midst85922553mids__t
midyear1343343midyear
mildest102812063mildest
millet84030743mille_t
mindset10313343mindse_t
minuet82621033minue_t
mioses84318853miose_s
miriest93619823miriest
mirkest13309723mirkest
misact10316693mi_sact
misadapt1345203misadapt
misagent11410723misagent
misassay1343203misassay
misate81222693mi_s_ate
misbegan1343243misbegan
misbegot1344773misbegot
misbias1139083misbias
miscast11312423miscast
miscreant1347573miscreant
miscreate1348893miscreate
miscut10614823mi_scut
misdate101413963mi_sdate
misdeals1147233misdeals
misdeed113211053misdeed
misdeem12217873misdeem
misdial1039643misdial
misdraw1345623misdraw
mise66043583mi_se__
misease92713043mi_sease
miseaten10310773mi_seaten
misedit10311043misedit
miser75430403mi_se_r
misers85025703mi_sers
misery114113543mi_sery
mises74740563mi_se_s
misevent1349223misevent
misfed124113023misfe_d
misfeed13389683misfeed
misfit112813833mi_sfit
misgraft1447203misgraft
mishap1338873mi_shap
misheard1446253misheard
mishears1338323mishears
mishit112618203mi_shit
miskal123710263mi_skal
miskeep1536403miskeep
mislay113510683mi_slay
misleads11358543misleads
mislearn1045343mislearn
mislearnt1195553mislearnt
misled94719313misle_d
mislit83019693mi_slit
mismate111415353mi_smate
mismeets12297733mismeets
mispart111113783mispart
mispen10312173mispe_n
mispens11311073mispens
misplan1147773misplan
misplant12410763misplant
misplay1436383misplay
misplead1345023misplead
misrate91319143mi_srate
misreads11268923misreads
misrelate1147933misrelate
misrely12319613misrely
miss65339423miss___
missaid10310303missaid
missals93914433missals
missays124010253missays
misseating131310943misseating
missends11368233missends
missense1037963missense
misshape1545983misshape
misshod1335873misshod
missies93423983missies
missile92815403missile
missing103619073missing
mission9312743mission
missis84417503miss_is
missive122413143missive
missorts1038323missorts
missouts1037623missouts
misspace1446523misspace
misspeaks1743063misspeaks
misspell1244303misspell
misspend1345243misspend
misstamp1443803misstamp
misstarts1145833misstarts
misstated1278973misstated
misstates11710633misstates
missteer1037223missteer
misstep11158463misstep
missteps12156143missteps
misstop11156413misstop
missuits1078023missuits
missus85312293miss_us
missy105617563miss__y
mist66154533mi_s__t
misteach1545443misteach
misted93625823miste_d
mistend103812523mistend
mister84728563miste_r
misterm114314513misterm
misters93927513misters
misteuk1335893misteuk
mistiest103018313mistiest
mistral91013643mistral
mistreats1148633mistreats
misuse83213643misuse__
misused104111283misuse_d
misuser93210443misuse_r
misusers10348083misusers
misuses93216023misuse_s
miswrit1249413miswrit
mitiest93520053mitiest
mitsvah1542163mitsvah
moistest1038763moistest
mossed94818893mosse_d
mosser84618273mosse_r
mossers94116193mossers
mosses85527683mosse_s
mossiest103112443mossiest
mostest9314793mostest
muscat10314663m_uscat
musket122818203muske_t
muskrat1346733muskrat
mussed94418903musse_d
mussel83412903musse_l
mussels9419843mussels
musses84624783musse_s
mussiest103112933mussiest
pissant91012503pissant
pissed94816933pisse_d
pisser84416383pisse_r
pissers95014753pissers
pisses84525083pisse_s
posset84923253posse_t
reseat64131493_reseat
russet6319433russe_t
seat47575563___seat
sisses64520603sisse_s
sissiest83412353sissiest
sweat85628403__sweat
tasset65925313tasse_t
tissual745193tissual
unseat64221023_unseat
wisent93516343wi_sent
wisest95016443wi_sest
wissed104114643wisse_d
wisses94619603wisse_s

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.393454684.5
2DLD Change Limit1340272465.92022639.7
3Display Results2462460.0962562.5
 (SQL Overall)1786912466.40927881.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.