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

509 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
miseat8292570(None) 
miseats92815781miseats
misseat93617231misseat
bisect10312872bisect
disseat83816922disseat
kismat123011672kismat
meat66359602m__eat
misact10316682misact
misate81222692mis_ate
miscast11312402miscast
miscut10614812miscut
misdate101413962misdate
misdeal1037662misdeal
misdealt1147972misdealt
mise66043572mise__
misease92713042misease
miseaten10310772miseaten
misedit10311042misedit
miser75430402mise_r
misers85025702misers
misery114113542misery
mises74740562mise_s
misfit112813832misfit
mishap1338862mishap
mishear1238392mishear
mishit112618192mishit
miskal123710262miskal
miskept1538922miskept
mislay113510682mislay
mislead10419972mislead
mislit83019692mislit
mismate111415352mismate
mismeet113215162mismeet
mismet103722372mismet
mispart111113772mispart
misrate91319142misrate
misread10339722misread
missal84314902missal
missay114112142missay
misseats104011682misseats
missent94318712missent
misset85028152misset
mist66154522mis__t
mistreat10313112mistreat
muscat10314652muscat
reseat64131492reseat
seat47575562__seat
unseat64221022unseat
wisent93516342wisent
wisest95016442wisest
absent84016993absent
airest63825263airest
asea46327183_asea_
assent65119953assent
assert64922573assert
asset55932263asse_t
basest84720493basest
beat66168303__beat
beset76739133bese_t
bidet84935623bide_t
bise66437093bise__
bisects1137133bisects
bises75435623bise_s
bistate9313813bistate
bleat75737003_bleat
caseate9314783caseate
caveat11417723caveat
cheat105732453_cheat
cineast9310523cineast
cist67244963cis__t
civet105828733cive_t
cleat76335063_cleat
coset75748843cose_t
cushat113513693cushat
defeat103817163defeat
desert72725493desert
diet57357533di_e_t
digest84019623digest
diktat11310693diktat
diquat1639763diquat
direct93817333direct
direst75024243direst
disbar938513disbar
discant103017253discant
discept12310623discept
disease83213843disease
diseur738843diseur
disject17268673disject
dismal92412243dismal
dismast10311233dismast
dismay12229473dismay
dispart101115283dispart
disrate81418523disrate
disseats93211503disseats
dissect103614133dissect
dissent84018683dissent
dissert83720693dissert
distal73615763distal
distant83519953distant
distent84120853distent
divert103922813divert
divest106820073divest
eat36989053___eat
eminent9313843eminent
exsect1558503exsect
exsert13414363exsert
feat76458223__feat
fiat76646643fi__at
fiesta938123fiesta
filet85540163file_t
finest94321733finest
fiscal1139333fiscal
fissate103010033fissate
fist76248423fis__t
gist56046763gis__t
great66034243_great
heat77061423__heat
hereat93527413hereat
hist76551543his__t
idea59122773_idea_
ideal65716393_ideal
ideas65919013_ideas
ideate7313683_ideate
ikat87626643_i_kat
ilea45931463_ilea_
ileac75814173_ileac
ileal56118083_ileal
inept73622153_inept
inert53234373_inert
inseam8329993inseam
insect83916583insect
insert64325253insert
inset54430863inse_t
isba61310873_isba_
isbas71010393_isbas
islet54527553_islet
kismats13257843kismats
kismet123414623kismet
kist86540793kis__t
likest104914383likest
lineal65616023lineal
linear65113333linear
lineate7815153lineate
lisente71210703lisente
list47055343lis__t
livest95315733livest
maist75535673mais__t
maleate94117543maleate
manat76039983m_anat
masa65034713mas_a_
masas75630413mas_as
mascot104016073mascot
maser75029973mase_r
masers84623453masers
massa75518923massa_
massas85116463massas
mast65959953mas__t
mat58083933m___at
mayest114614793mayest
mead75531603m__ead
meal65643173m__eal
mean65538083m__ean
meant76537203m__eant
meats75034053m__eats
meaty107021313m__eaty
meet65350553m__eet
melt65752893m__elt
merest84725113merest
mesa67025483mes_a_
mesas76823203mes_as
mescal104113483mescal
mesial84818083mesial
mesian84315503mesian
messan83912063messan
met56072433m__e_t
meta65932413m__eta
miasma1097563miasma_
miasmal1176743miasmal
miasmas1167743miasmas
miasmata1244503miasmata
mica86428243mi_ca_
micas96823053mi_cas
mice87442223mice__
micell1098193micell
micra96214973micra_
midcap1336473midcap
midday13327503midday
midget103718443midget
midgut103510053midgut
midst85922553mi_dst
midway15327153midway
midyear1343343midyear
mien65028353mi_e_n
miens76118303mi_ens
might113827083mi_ght
migrant10314313migrant
migrate101314163migrate
mihrab1335523mihrab
mike105535283mike__
miked125020453mike_d
mikes115129893mike_s
mikra114610313mikra_
mikvah18143473mikvah
mikvot1556763mikvot
mildest102812063mildest
mile66352563mile__
mileage10299313mileage
miler75733063mile_r
milers84625163milers
miles74645073mile_s
milia72719563milia_
millet84030743millet
milpa92111403milpa_
milpas101710273milpas
milt65455803mi__lt
mimbar1297483mimbar
mime85736393mime__
mimed105622733mime_d
mimeo96018683mime_o
mimeos104511543mimeos
mimer94825763mime_r
mimers105520183mimers
mimes95732023mime_s
mina65136903mi_na_
minae75627723mi_nae
minas75434113mi_nas
mindset10313343mindse_t
mine67256153mine__
mined85333353mine_d
miner76933543mine_r
mineral9312733mineral
miners84126633miners
mines75651953mine_s
mint66758043mi__nt
minuet82621033minuet
minyan1138173minyan
mioses84318853miose_s
mire66748223mire__
mired85729223mire_d
mires75640883mire_s
mirex146816623mire_x
miriest93619823miriest
mirkest13309723mirkest
mirza16410443mirza_
mirzas1738173mirzas
mis58162613mis___
misacts1139353misacts
misadapt1345193misadapt
misadd1037163misadd
misagent11410723misagent
misaim10311853misaim
misbegan1343243misbegan
misbegot1344773misbegot
misbias1139073misbias
miscall1139643miscall
miscasts1238343miscasts
miscite11314383miscite
miscreant1347563miscreant
miscreate1348893miscreate
miscue10412223miscue
miscuts1139183miscuts
misdated121211113misdated
misdates111113623misdates
misdeals1147223misdeals
misdeed113211053misdeed
misdeem12217873misdeem
misdial1039643misdial
misdid10510563misdid
misdo85413183mis_do
misdraw1345623misdraw
miseases102614343miseases
miseating121215433miseating
misedits1147963misedits
misenter10310833misenter
misentry1345773misentry
miserly12329823miserly
misevent1349223misevent
misfaith1644543misfaith
misfed124113023misfed
misfeed13389683misfeed
misfits12279663misfits
misgave13298283misgave
misgraft1447183misgraft
mishaps1438713mishaps
misheard1446253misheard
mishears1338323mishears
mishits122513083mishits
miskals13369763miskals
miskeep1536403miskeep
mislaid1039293mislaid
mislain9311243mislain
mislays12349243mislays
misleads11358543misleads
mislearn1045343mislearn
mislearnt1195553mislearnt
misled94719313misled
mislie83219153mislie
mismade12129353mismade
mismake15139373mismake
mismark1536703mismark
mismatch1743933mismatch
mismated131111333mismated
mismates121114553mismates
mismeets12297733mismeets
misname11119483misname
miso67229893mis__o
misos76523293mis_os
mispage12310523mispage
mispaint121111893mispaint
misparts12108173misparts
mispatch1743853mispatch
mispen10312173mispen
mispens11311073mispens
misplan1147773misplan
misplant12410753misplant
misplay1436383misplay
misplead1345023misplead
misrated111315383misrated
misrates101318233misrates
misreads11268923misreads
misrelate1147933misrelate
misrely12319603misrely
miss65339413mis__s
missaid10310293missaid
missals93914423missals
missays124010253missays
misseated12610113misseated
missed94423603missed
missel85216523missel
missels94614813missels
missend104411373missend
misses85130873misses
missets94516573missets
missis84417503missis
missort9314653missort
missout9412663missout
misspeak1643493misspeak
misspelt1247273misspelt
misspent1259173misspent
misstart10410033misstart
misstate10711333misstate
missuit9911303missuit
missus85312293missus
missy105617563mis_sy
mistake131312613mistake
misteach1545443misteach
misted93625823misted
mistend103812523mistend
mister84728563mister
misterm114314513misterm
misters93927503misters
misteuk1335893misteuk
mistiest103018313mistiest
mistral91013633mistral
mistreats1148633mistreats
mists76633903mis_ts
misty106120453mis_ty
misuse83213643misuse
miswrit1249413miswrit
mite66249403mite__
miter75734793mite_r
miters84328773miters
mites75141803mite_s
mitiest93520053mitiest
mitral81314323mitral
mitsvah1542163mitsvah
mitt66145483mi__tt
mixed155717253mixe_d
mixer145017643mixe_r
mixers154513563mixers
mixes147224403mixe_s
mixt136831913mi__xt
mizen164815273mize_n
mizens174610253mizens
moat66352033m__oat
modest93818453modest
moist76033573mois__t
moistest1038763moistest
molest85022743molest
moment103319683moment
mosey105922873mose_y
moseys114711703moseys
moshav1446053moshav
most66554203mos__t
mostest9314793mostest
motet75641193mote_t
mudcat11311203mudcat
muleta839233muleta
musca9311763musca_
muscae10410673muscae
muscats1138933muscats
muse67136033muse__
mused85524583muse_d
muser76024123muse_r
musers84719093musers
muses75134303muse_s
musette938433musette
museum1037703museum
musket122818203musket
muskit122813253muskit
muskrat1346733muskrat
must65145443mus__t
mutest84218053mutest
myself1445593myself
mysost1138263mysost
neat46356783__neat
nicest82315663nicest
nisei54214353nise_i
niseis63512023niseis
onset54730173onse_t
orgeat7515033orgeat
outeat62824533outeat
peat65967933__peat
peseta8310573peseta
pieta75421753pi_eta
pilea75123953pilea_
pileate93815923pileate
pineal84817683pineal
pineta85815563pineta
pipet95533323pipe_t
pissant91012503pissant
pleat74734473_pleat
reheat94423943reheat
repeat85127213repeat
resat55139683res_at
reseal64819643reseal
reseats74319583reseats
reseau64216213reseau
resect84424703resect
resent63833623resent
reset55051863rese_t
rident7520193rident
rifest93114583rifest
ripest84317933ripest
rise45945233rise__
risen54621883rise_n
riser55431053rise_r
risers64624783risers
rises55244043rise_s
rivet85636363rive_t
roseate7613453roseate
roset55945243rose_t
sat36288483__s_at
scat65848373__scat
sea36161293__sea_
seal45654373__seal
seam66645973__seam
sear47353843__sear
seas45755273__seas
seats54844343__seats
sect67443623__sect
sent46963013__sent
sept65844363__sept
set36681253__se_t
seta45637313__seta
sett45949053__sett
sext117338093__sext
shat76456593__shat
siesta639503siesta
silent64125843silent
sisal54217733sis_al
sises55233833sise_s
skat87037893__skat
slat46959023__slat
spat66548523__spat
stat47352693__stat
swat77244443__swat
sweat85628403_sweat
teat45963633__teat
threat95020463threat
tinea54923153tinea_
tineal66216153tineal
tineas64616473tineas
tipcat10312653tipcat
treat56240353_treat
trisect939733trisect
unseal63315473unseal
unseam83313143unseam
unseats73012853unseats
unsent63820963unsent
unset54532433unse_t
upbeat10911513upbeat
upsent83314063upsent
upset73222593upse_t
vilest9416843vilest
vineal94814743vineal
visa76323873vis_a_
visaed104110503visaed
visas84317653vis_as
vise75632673vise__
vised95518763vise_d
viseed105310983viseed
vises84427773vise_s
visit8320963vis_it
vista85416603vista_
vistas94513273vistas
visual938803visual
wheat114924573_wheat
widest104517003widest
wise75737343wise__
wiseass1035823wiseass
wised95123343wise_d
wisely122711713wisely
wisents10249063wisents
wiser85522803wise_r
wises85633193wise_s
wisha114910853wisha_
wist78049293wis__t
zibet16419733zibe_t

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127165095.89019136.8
3Display Results5095090.1902678.9
 (SQL Overall)1786915096.22028728.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.