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

218 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
missions1031190(None) 
emissions1146921emissions
fissions1138031fissions
mission9312741mission_
omissions1146151omissions
admissions1343462admissions
cessions1039852cessions
demissions1345662demissions
emission1047672emission_
fission1038732fission_
mansions1069792mansions
millions101712432millions
minions93314622mi_nions
miscoins12311082miscoins
misjoins1736912misjoins
missies93423982missi_es
missiles103015082missiles
missing103619072missi_ng
missional1146062missional
missioned1248602missioned
missioner1147882missioner
missioners1245852missioners
missis84417502missi__s
missises103513692missises
missives133212842missives
misstops12176412misstops
misunions1154532misunions
omission1046532omission_
passions10310582passions
remissions1246612remissions
scissions1145432scissions
sessions839722sessions
visions10311022vi_sions
admission1243733admission_
assigns836193_assigns
basions94213953_basions
bassoons1036553bassoons
bastions10411693bastions
billions102211793billions
bisons83914373bi_s_ons
caissons1036283caiss_ons
cassinos10309353cassinos
cession939813cession_
cissies94116153cissi_es
cissoids1145363cissoids
cistrons102710623cistrons
commissions1745263commissions
cushions1335693cushions
demission1246033demission_
dictions111812673dictions
disjoins1647623disjoins
dislimns1144813dislimns
dismissions1454003dismissions
dissing94517683dissi_ng
disunions1055973disunions
divisions1396283divisions
elisions82210423elisions
elusions82610083elusions
emersions1147283emersions
emulsions1145343emulsions
erasions8310983erasions
erosions8310343erosions
essoins737603_essoins
evasions1136543evasions
fashions1437243fashions
fictions132410743fictions
fissional1245123fissional
fissioned1345523fissioned
frissons1145043friss_ons
fusions1039153_fusions
gibsons1045043gibs_ons
gossoons944893gossoons
hessians1145053hessians
hissies103915823hissi_es
hissing114213143hissi_ng
hissings12556753hissings
impassions1444843impassions
inions64417003_i_nions
isogons8217613_isogons
jillions15178283jillions
kissing122911053kissi_ng
lesions73813873_lesions
lessons73811023less_ons
liaisons844293liaisons
malisons1048783malisons
mansion9611543mansion_
mascons113411583m_ascons
masons83916513m_as_ons
massicots1343843massicots
massifs1237743massi_fs
massing104318023massi_ng
mentions10312893mentions
mesons83215843m_es_ons
messans92710463mess_ans
messiahs1343963messiahs
messing103916393messi_ng
mestinos1048163mestinos
microns113814783mi_crons
midirons1145883midirons
midnoons1144403midnoons
mignons1037863mi_gnons
mikrons13428413mi_krons
million91813143million_
minion83416243mi_nion_
miosis83615163miosi__s
mirins83918903mi_ri_ns
mirlitons1144113mirlitons
misaims11310113misai_ms
misaligns1244773misaligns
misassigns1352413misassigns
misatone1049763misatone
misatones1148933misatones
misbias1139083misbi_as
misbills1246083misbills
misbind1258273misbi_nd
misbinds1345163misbinds
miscites12313783miscites
miscoin11311433miscoin_
miscooks1645463miscooks
misdials1137493misdials
misdoes10312493mi_sdoes
misdoing1238803misdoing
misdoings1344423misdoings
misdone10310863mi_sdone
misfiles133110983misfiles
misfires132210583misfires
misfits12279663misfi_ts
misgives14329293misgives
misgrows1444963misgrows
mishits122513083mishi_ts
misjoin1637693misjoin_
miskicks1544763miskicks
misknows1743063misknows
mislies92922283misli_es
mislikes143311833mislikes
mislives132912153mislives
misos76523293mi_s_o_s
mispens11311073mi_spens
misplans1238863misplans
mispoint121012363mispoint
mispoints13106633mispoints
misprisions1553153misprisions
missals93914423miss_als
missays124010253miss_ays
misseats104011683misseats
missels94614813miss_els
missend104411373miss_end
missends11368233missends
missense1037963miss_ense
missent94318713miss_ent
misses85130873miss__es
missets94516573miss_ets
misshod1335873missho_d
missile92815403missi_le
missilry1344653missilry
missionary1553663missionary
missioning1347403missioning
missionize21184413missionize
missionizes22123793missionizes
missive122413143missi_ve
missort9314653miss_ort
missorts1038323missorts
missound1145113missound
missounds1243533missounds
missout9412663miss_out
missouts1037623missouts
misspend1345243misspend
misspends1443853misspends
misspent1259173misspent
misspoke1645413misspoke
missteps12156143missteps
misstop11156413missto_p
missuits1078023missuits
missus85312293miss__us
missuses10309683missuses
mistbows1543993mistbows
mistimes12612613mistimes
misting103623383misti_ng
misunion1084943misunion_
misusing1138893misusi_ng
monsoons1047343monsoons
morions94014643m_orions
morrions1077673morrions
mossing103915423mossi_ng
motions94215003m_otions
mullions101910353mullions
munnions1035273munnions
muslins9312213musli_ns
mussing104015543mussi_ng
myosins12278963myosi_ns
nasions73112383_nasions
passion9310883passion_
pensions10311693pensions
permissions1545333permissions
pillions101610923pillions
pinions93413603pi_nions
pissing103914803pissi_ng
pissoirs1044693pissoirs
pistons93016373pi_stons
plosions1038023plosions
pulsions1037713pulsions
reemissions1344153reemissions
remission1147333remission_
scions82612243__scions
scission1045563scission_
session739763session_
siskins1159583siski_ns
sissies73716603sissi_es
suasions838783suasions
submissions1553693submissions
tensions8310223tensions
torsions839183torsions
versions11310353versions
vibrions1345093vibrions
virions1039873vi_rions
vision9311313vi_sion_
wissing113212943wissi_ng
zillions17168073zillions

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.443403365.7
2DLD Change Limit1461622187.32619951.1
3Display Results2182180.0932344.1
 (SQL Overall)1786912187.86222728.4
 
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.