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

242 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
missive12241314(None) 
emissive1345921emissive
massive12289771massive
misgive13339031misgive
mislive122812691mislive
missile92815401missile
missives133212841missives
omissive1345101omissive
admissive1543022admissive
dissave1139412dissave
fissile10269652fissile
jussive1734292jussive
midsize1946392midsize
miscite11314382miscite
misdrive1446682misdrive
misfile122611552misfile
misfire12229892misfire
misgave13298282misgave
misgiven14245902misgiven
misgives14329292misgives
mislie83219152misli_e
mislike132914832mislike
mislived14328782mislived
mislives132912152mislives
mismove1437082mismove
missies93423982missies
missiles103015082missiles
missing103619072missing
mission9312742mission
missis84417502missi_s
missises103513692missises
mistime11312612mistime
passive12239592passive
remissive1445772remissive
tussive1035302tussive
visive1257872vi_sive
abusive1245283abusive
amusive1246253amusive
assize1538633_assize
cassine93817283cassine
cissies94116153cissies
costive12312843costive
cursive1237833cursive
dassie74615573dassi_e
dislike122913453dislike
dismissive1652973dismissive
dissaved1337313dissaved
dissaves1239413dissaves
disseise939853disseise
disseize1847183disseize
disserve1287443disserve
dissever12107653dissever
dissing94517683dissing
dissolve1246103dissolve
divisive1545013divisive
elusive1057003elusive
emission1047673emission
emulsive1344533emulsive
erosive1039193erosive
evasive1344663evasive
festive1339773festive
fictive1537023fictive
fissate103010033fissate
fission1038733fission
fissiped1444153fissiped
fissure1036783fissure
gussie72910153gussi_e
hessite1038993hessite
hissier103410503hissier
hissies103915823hissies
hissing114213143hissing
impassive1644243impassive
inside7613453_inside
issue559213_iss_ue
jussives1833843jussives
kissing122911053kissing
lassie64917743lassi_e
lissome937583lissome
mashie11315933mashi_e
massage1039893massage
masse75125293mass__e
massier93615223massier
massif11412533massi_f
massifs1237743massifs
massing104318023massing
massively1744153massively
message1037833message
messiah1246793messiah
messier93412923messier
messily12298813messily
messing103916393messing
midlife13248303midlife
midline102315103midline
midlives14287463midlives
midsized2144733midsized
midsole1037813midsole
midwife16225523midwife
midwived18263553midwived
midwives17274803midwives
millime112511403millime
milline92519113milline
miniver1238393mi_niver
miosis83615163miosi_s
misaim10311853misai_m
misaimed1338093misaimed
misaims11310113misaims
misate81222693mi_sate
misaver1249813mi_saver
misbias1139083misbias
misbill1137033misbill
misbind1258273misbind
miscible1447673miscible
miscited13310423miscited
miscites12313783miscites
miscode12310413miscode
miscue10412223mi_scue
misdate101413963misdate
misdial1039643misdial
misdid10510573misdi_d
misdivide16103793misdivide
misdone10310863misdone
misdriven1544073misdriven
misdrives1546213misdrives
misdrove1445433misdrove
mise66043583mi_s__e
misease92713043misease
misfiled14278653misfiled
misfiles133110983misfiles
misfired14238543misfired
misfires132210583misfires
misfit112813833misfi_t
misfits12279663misfits
misguide12145703misguide
mishit112618193mishi_t
mishits122513083mishits
miskick1435613miskick
mislies92922283mislies
misliked15319513misliked
misliker14319573misliker
mislikes143311833mislikes
mislit83019693misli_t
mismade12129353mismade
mismake15139373mismake
mismate111415353mismate
mismoved1635653mismoved
mismoves1537293mismoves
misname11119483misname
mispage12310523mispage
mispoise1248263mispoise
misprice1448133misprice
misprize2147543misprize
misraise10410523misraise
misrate91319143misrate
misrule939353misrule
miss65339423miss___
missable12311533missable
missaid10310303missaid
missal84314903miss_al
missals93914423missals
missay114112143miss_ay
missays124010253missays
misseat93617233misseat
missed94423603miss_ed
missel85216523miss_el
missels94614813missels
missend104411373missend
missense1037963missense
missent94318713missent
misses85130873miss_es
misset85028153miss_et
missets94516573missets
misshape1545973misshape
misshod1335873misshod
missileer1145583missileer
missilery1444553missilery
missilry1344653missilry
missioned1248603missioned
missioner1147883missioner
missions10311903missions
missort9314653missort
missout9412663missout
misspace1446523misspace
misspoke1645413misspoke
misstate10711343misstate
missteer1037223missteer
misstep11158463misstep
misstop11156413misstop
misstrike1544893misstrike
misstyle1345273misstyle
missuit9911303missuit
missuited1257023missuited
missuits1078023missuits
missus85312293miss_us
missuses10309683missuses
missy105617563miss__y
mistake131312623mistake
mistier93418713mistier
mistily122612343mistily
mistimed1339123mistimed
mistimes12612613mistimes
misting103623383misting
mistitle1038523mistitle
mistune9310653mistune
mistype14126523mistype
misusage1145173misusage
misuse83213643mi_suse
misusing1138893misusing
miswrite1348923miswrite
misyoke1635823misyoke
mossier94413813mossier
mossing103915423mossing
mosslike1435453mosslike
motive113112143m_otive
muskie123412543muski_e
muspike1536043muspike
mussier93314363mussier
mussily12279773mussily
mussing104015543mussing
omissible1344093omissible
omission1046533omission
passives13228823passives
pensive122610393pensive
permissive1753973permissive
piscine11610973piscine
pismire1135353pismire
pissing103914803pissing
plosive1236673plosive
restive10315933restive
rissole739783rissole
scissile1044623scissile
sessile739523sessile
shive114423423__shive
sissier73711363sissier
sissies73716603sissies
skive124614113__skive
suasive1037853suasive
submissive1762833submissive
swive115316193__swive
tassie66017023tassi_e
tensive10269913tensive
tissue637333tiss_ue
wissing113212943wissing

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 Limit1340272426.07622058.4
3Display Results2422420.0932602.2
 (SQL Overall)1786912426.57527177.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.