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

237 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
missives13321284(None) 
misgives14329291misgives
mislives132912151mislives
missies93423981missi_es
missiles103015081missiles
missises103513691missises
missive122413141missive_
cissies94116152cissi_es
dissaves1239412dissaves
emissive1345922emissive_
hissies103915822hissi_es
jussives1833842jussives
massive12289772massive_
midlives14287462midlives
midwives17274802midwives
miscites12313782miscites
misdrives1546212misdrives
misfiles133110982misfiles
misfires132210582misfires
misgive13339032misgive_
misgiven14245902misgiven
mislies92922282misli_es
mislikes143311832mislikes
mislive122812692mislive_
mislived14328782mislived
mismoves1537292mismoves
misses85130872miss__es
missile92815402missile_
missions10311902missions
missis84417502missi__s
missuses10309682missuses
mistimes12612612mistimes
omissive1345102omissive_
passives13228822passives
sissies73716602sissi_es
admissive1543023admissive_
assizes1638453_assizes
bossies94116833bossi_es
cassines103116613cassines
cassises103811743cassises
cursives1337103cursives
dassies84418663dassi_es
dislikes132810843dislikes
dissave1139413dissave_
dissaved1337313dissaved
disseises1039333disseises
disseizes1946823disseizes
disserves1388063disserves
disses75225963diss__es
dissever12107653dissever
dissevers1386863dissevers
dissolves1346233dissolves
distaves12311403distaves
emissions1146923emissions
fishwives2142173fishwives
fissile10269653fissile_
fissions1138033fissions
fissiped1444153fissiped
fissipeds1542423fissipeds
fissures1136573fissures
gipsies1039903gipsi_es
gussies82813303gussi_es
hessites1138613hessites
hisses94719353hiss__es
hissier103410503hissi_er
hissiest112911093hissi_est
hissings12556753hissings
hussies103213293hussi_es
huswives1742933huswives
insides8512653_insides
issues648803_iss_ues
jussive1734293jussive_
kisses104217333kiss__es
lassies74420103lassi_es
mashies12318253mashi_es
massages1159883massages
masses85028713mass__es
massier93615223massi_er
massiest103314423massi_est
massifs1237743massi_fs
massiness112810143massiness
massively1744153massively
mastixes1738253mastixes
messages1138233messages
messes84924343mess__es
messiahs1343963messiahs
messier93412923messi_er
messiest103112423messi_est
messiness11248223messiness
middies113116153middi_es
midlines112613333midlines
midsize1946393midsize_
midsized2144733midsized
midsoles1137763midsoles
midwifes17234713midwifes
midwived18263553midwived
millimes122411373millimes
millines102718063millines
mimesises1345363mimesises
minishes13310583minishes
miniver1238393mi_niver
minivers1337483mi_nivers
minnies93617363minni_es
mioses84318853mios__es
miosis83615163miosi__s
misaimed1338093misaimed
misaims11310113misai_ms
misaver1249813mi_saver
misavers1348063mi_savers
misbias1139083misbi_as
misbiases1346253misbiases
misbills1246083misbills
misbinds1345163misbinds
miscite11314383miscite_
miscited13310423miscited
miscodes13310423miscodes
miscues11312393mi_scues
misdates111113633misdates
misdials1137493misdials
misdivides17113303misdivides
misdoes10312493mi_sdoes
misdrive1446683misdrive_
misdriven1544073misdriven
miseases102614343miseases
miseries10320403miseries
mises74740563mi_s__es
misfile122611553misfile_
misfiled14278653misfiled
misfire12229893misfire_
misfired14238543misfired
misfits12279663misfi_ts
misgave13298283misgave_
misguides13165333misguides
mishits122513083mishi_ts
miskicks1544763miskicks
mislie83219153misli_e_
mislike132914833mislike_
misliked15319513misliked
misliker14319573misliker
mislikers15317063mislikers
mismakes16129883mismakes
mismates121114563mismates
mismove1437083mismove_
mismoved1635653mismoved
misnames12119883misnames
mispages13311183mispages
mispoises1348353mispoises
misprices1547913misprices
misprizes2247223misprizes
misraises1149933misraises
misrates101318243misrates
misrules1039383misrules
missals93914423miss_als
missays124010253miss_ays
misseats104011683misseats
missed94423603miss__ed
missel85216523miss__el
missels94614813miss_els
missends11368233missends
missense1037963missense
missenses1148033missenses
misset85028153miss__et
missets94516573miss_ets
misshapes1645913misshapes
missileer1145583missileer
missileers1244193missileers
missilery1444553missilery
missilries1244093missilries
missilry1344653missilry
missing103619073missi_ng
mission9312743missi_on
missioned1248603missioned
missioner1147883missioner
missioners1245853missioners
missorts1038323missorts
missouts1037623missouts
misspaces1546513misspaces
misstates11710633misstates
missteer1037223missteer
missteers1135913missteers
misstep11158463miss_tep
missteps12156143missteps
misstops12176413misstops
misstrikes1644363misstrikes
misstyles1445023misstyles
missuited1257023missuited
missuits1078023missuits
missus85312293miss__us
mistakes141213413mistakes
mistier93418713misti_er
mistiest103018313misti_est
mistime11312613mistime_
mistimed1339123mistimed
mistiness111911633mistiness
mistitles1147953mistitles
mistunes10311133mistunes
mistypes15116713mistypes
misusages1244973misusages
misuses93216023mi_suses
miswrites1447983miswrites
misyokes1735513misyokes
mitises9315543mi_tises
mosses85527683moss__es
mossier94413813mossi_er
mossiest103112443mossi_est
mossiness11258323mossiness
motives123611893m_otives
muskies133614673muski_es
muspikes1635243muspikes
musses84624783muss__es
mussier93314363mussi_er
mussiest103112933mussi_est
mussiness11238303mussiness
omissions1146153omissions
passive12239593passive_
pismires1235883pismires
pisses84525083piss__es
plosives1335893plosives
prissies101712003prissi_es
pussies93615693pussi_es
remissive1445773remissive_
rissoles839113rissoles
sassies74719263sassi_es
shives124921413__shives
sisses64520603siss__es
sissier73711363sissi_er
sissiest83412353sissi_est
sissiness8217963sissiness
skives134113943__skives
swives123915183__swives
tassies74918933tassi_es
tissues737463tiss_ues
tussises835433tussises
tussive1035303tussive_
visive1257873vi_sive_
wisses94619603wiss__es
wussies103411083wussi_es

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622377.20320291.8
3Display Results2372370.0932548.4
 (SQL Overall)1786912377.71923149.5
 
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.