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

291 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
missent9431871(None) 
dissent84018681dissent
misseat93617241misseat
missend104411371missend
misset85028151misse_t
misspent1259171misspent
assent65119952_assent
disseat83816922disseat
dissect103614132dissect
dissents93411862dissents
dissert83720692dissert
distent84120852distent
misagent11410722misagent
miseat82925712mi_seat
misevent1349222misevent
miskept1538922miskept
mismeet113215162mismeet
mismet103722372misme_t
mispen10312172mispen_
mispens11311072mispens
misseats104011682misseats
missed94423602misse_d
missel85216522misse_l
missels94614812missels
missends11368232missends
missense1037962missense
misses85130872misse_s
missets94516572missets
missing103619072missing
missort9314652missort
missout9412662missout
misspelt1247272misspelt
misspend1345242misspend
missuit9911302missuit
mistend103812522mistend
pissant91012502pissant
wisent93516342wi_sent
absent84016993_absent
ailment9314233ailment
amassment1346413amassment
ascent84519653_ascent
assents74512223_assents
assert64922583_assert
asset55932263_asse_t
basset85225383basse_t
bassett94213863bassett
bisect10312873bi_sect
cassena9287843cassena
cassene93111543cassene
consent93723113consent
cosset84125863cosse_t
descent102616293descent
dessert82916453dessert
diluent8310263diluent
discant103017263discant
discept12310623discept
disject17268673disject
dispend11289413dispend
disseats93211503disseats
dissects11279243dissects
dissed85220183disse_d
dissented1199723dissented
dissenter1059133dissenter
disserts92411813disserts
disses75225963disse_s
dissident1147693dissident
dissing94517683dissing
distant83519953distant
distend93312073distend
eminent9313853emi_nent
existent1548263existent
figment1379743figment
fishnet13410343fishnet
fitment12710303fitment
ginseng933433ginseng
gusset7316433gusse_t
hissed104114453hisse_d
hisself1335913hisself
hisser94713793hisse_r
hissers104112313hissers
hisses94719353hisse_s
hissiest112911093hissiest
hissing114213143hissing
incent83320723_incent
indent73021243_indent
insect83916583_insect
insert64325253_insert
inset54430863_inse_t
intent63122773_intent
invent93316363_invent
islet54527553_isle_t
issei568573_isse_i
isseis638563_isseis
issuant748263_issuant
jessant1438443jessant
kismet123414623kisme_t
kissed114412853kisse_d
kisser104212453kisse_r
kissers114211293kissers
kisses104217333kisse_s
kissing122911053kissing
lessen64212433lessen_
lessens7409383lessens
lisente71210703li_sente
listen64816813listen_
listens74014133listens
margent10316693margent
masse75125293masse__
massed94421323masse_d
masses85028713masse_s
masseur935703masseur
massiest103314423massiest
massing104318023massing
messan83912063messan_
messans92710463messans
messed95018183messe_d
messes84924343messe_s
messiest103112423messiest
messing103916393messing
messmen1137393messmen_
midden104112853midden_
middens11379383middens
midget103718453midge_t
midst85922553mids__t
mien65028363mi__en_
miens76118303mi__ens
migrant10314313migrant
milden94113153milden_
mildens10339933mildens
mildest102812063mildest
millet84030743mille_t
mindset10313343mindse_t
mint66758063mi___nt
minuend1035383minuend
minuet82621033minue_t
miocene1147923miocene
mioses84318853miose_s
miriest93619823miriest
mirkest13309723mirkest
misact10316693mi_sact
misagents1246793misagents
misbegot1344773misbegot
misbind1258273misbind
miscast11312423miscast
miscount1299473miscount
miscreant1347573miscreant
miscut10614823mi_scut
misdeal1037663misdeal
misdealt1147983misdealt
misdeed113211053misdeed
misdeem12217873misdeem
misdone10310863misdone
mise66043583mi_se__
miseats92815793mi_seats
misedit10311043misedit
misenter10310833mi_senter
misentry1345773mi_sentry
miser75430403mi_se_r
misers85025703mi_sers
misery114113543mi_sery
mises74740563mi_se_s
misevents1456003misevents
misfed124113023misfe_d
misfeed13389683misfeed
misfit112813833mi_sfit
mishear1238393mishear
mishit112618203mi_shit
miskeep1536403miskeep
misknew1633883misknew
mislead10419973mislead
mislearnt1195553mislearnt
misled94719313misle_d
mislit83019693mi_slit
mismeets12297733mismeets
misorient11510893misorient
mispaint121111893mispaint
mispart111113783mispart
misplant12410763misplant
mispoint121012363mispoint
misprint12912973misprint
misread10339723misread
misrely12319613misrely
miss65339423miss___
missaid10310303missaid
missal84314903miss_al
missals93914433missals
missay114112143miss_ay
missays124010253missays
misseated12610113misseated
missenses1148033missenses
misshod1335873misshod
missies93423983missies
missile92815403missile
mission9312743mission
missions10311903missions
missis84417503miss_is
missive122413143missive
missorts1038323missorts
missound1145113missound
missouts1037623missouts
misspeak1643493misspeak
misspell1244303misspell
misspends1443853misspends
misstart10410043misstart
misstate10711343misstate
missteer1037223missteer
misstep11158463misstep
missteps12156143missteps
misstop11156413misstop
missuits1078023missuits
missus85312293miss_us
missy105617563miss__y
mist66154533mi_s__t
misted93625823miste_d
mistends11419593mistends
mister84728563miste_r
misterm114314513misterm
misters93927513misters
misteuk1335893misteuk
mistiest103018313mistiest
misting103623383misting
mistreat10313113mistreat
mistune9310653mistune
misuse83213643misuse__
misused104111283misuse_d
misuser93210443misuse_r
misusers10348083misusers
misuses93216023misuse_s
misusing1138893misusing
miswrit1249413miswrit
mitiest93520053mitiest
mitten83914093mitten_
mittens9349883mittens
mizen164815273mi_zen_
mizens174610253mi_zens
mizzen16447953mizzen_
mizzens17366123mizzens
moisten93110143moisten_
moistens10268773moistens
moistest1038763moistest
moment103319683m_oment
mordent10313993mordent
mossed94818893mosse_d
mosser84618273mosse_r
mossers94116193mossers
mosses85527683mosse_s
mossiest103112443mossiest
mossing103915423mossing
mostest9314793mostest
musket122818203muske_t
mussed94418903musse_d
mussel83412903musse_l
mussels9419843mussels
musses84624783musse_s
mussiest103112933mussiest
mussing104015543mussing
nascent9610523nascent
passant9813943passant
pigment12510733pigment
pissants1097363pissants
pissed94816933pisse_d
pisser84416383pisse_r
pissers95014753pissers
pisses84525083pisse_s
pissing103914803pissing
posset84923253posse_t
present94022733present
puissant10105393puissant
resent63833623_resent
rident7520193ri_dent
ringent8315153ringent
risen54621883ri_sen_
russet6319433russe_t
scent75831623__scent
sent46963013___sent
shent85933503__shent
silent64125843si_lent
sisses64520603sisse_s
sissiest83412353sissiest
spent75532833__spent
stent55634513__stent
tasset65925313tasse_t
unsent63820963_unsent
unspent92610893unspent
upsent83314063_upsent
violent102110813violent
wisents10249063wi_sents
wisest95016443wi_sest
wissed104114643wisse_d
wisses94619603wisse_s
wissing113212943wissing

Search took 8 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 Limit1340272916.93619323.4
3Display Results2912910.1102645.5
 (SQL Overall)1786912917.45223978.9
 
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.