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

221 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
massive1228977(None) 
missive122413141missive
passive12239591passive
amusive1246252amusive
assize1538632_assize
cassine93817282cassine
dassie74615572dassi_e
emissive1345922emissive
impassive1644242impassive
jussive1734292jussive
lassie64917742lassi_e
mashie11315932mashi_e
massage1039892massage
masse75125292mass__e
massier93615222massier
massif11412532massi_f
massifs1237742massifs
massing104318022massing
massively1744152massively
misgive13339032misgive
mislive122812692mislive
missile92815402missile
missives133212842missives
omissive1345102omissive
passives13228822passives
tassie66017022tassi_e
tussive1035302tussive
abusive1245283abusive
active11313743_active
admissive1543023admissive
alive85722513_a_live
alsike1047913_alsike
amassing1138003amassing
amative12311733amative
amosite9313163amosite
arrive91311793_arrive
arsine64021043_arsine
aside65122083_a_side
aspire8612123_aspire
assign736783_assign
assist6314603_assist
assizes1638453_assizes
asslike1137373_asslike
assume897563_assume
assure6610773_assure
bassi77019323bassi__
bassinet10312843bassinet
bassist9312743bassist
bastile9313913bastile
brassie93411523brassi_e
capsize2037623capsize
captive1438973captive
caressive1445823caressive
cassava1255003cassava
cassene93111543cassene
cassia83714763cassi_a
cassias93514343cassias
cassina94113163cassina
cassines103116613cassines
cassino93512433cassino
cassis84818853cassi_s
cassises103811743cassises
costive12312843costive
cursive1237833cursive
dassies84418663dassies
dative10311813da_tive
dayside1236173dayside
dissave1139413dissave
elusive1057003elusive
emulsive1344533emulsive
erosive1039193erosive
evasive1344663evasive
falsie93513853falsi_e
farside1138603farside
fasciae1247523fasciae
fascine12510583fascine
festive1339773festive
fissile10269653fissile
gassier83812573gassier
gassily1137813gassily
gassing94216333gassing
gawsie1038463gawsi_e
glassie8329493glassi_e
glassine9329313glassine
gussie72910153gussi_e
hassium1236133hassium
hassle93711593hass_le
hessite1038993hessite
jasmine1636643jasmine
jassid1467223jassi_d
jassids1586143jassids
jussives1833843jussives
lassi56316853lassi__
lassies74420103lassies
lassis65216703lassi_s
machine14313493machine
magpie1139093magpi_e
maile75232223ma__ile
maize164618563ma__ize
malaise9312673malaise
malice104818483ma_lice
maline84529083ma_line
mamie95826003ma_mi_e
mammie94313783mammi_e
manlike133012783manlike
mannite9312903mannite
manse75528233mans__e
mansion9611543mansion
manwise1239183manwise
maplike15299273maplike
marine84230403ma_rine
marline93320953marline
marlite92917073marlite
marmite112413993marmite
marse76231153mars__e
mashies12318253mashies
mashing134422243mashing
masjid16187323masji_d
masjids17175403masjids
masking145116613masking
masklike1335593masklike
masonite1049683masonite
masque17249383ma_sque
mass66044943mass___
massa75518923mass__a
massacre1244743massacre
massaged1236753massaged
massager1136873massager
massages1159883massages
massas85116463mass_as
massed94421323mass_ed
masses85028713mass_es
masseter1037063masseter
masseur935703masseur
masseuse1044253masseuse
massicot1246583massicot
massiest103314423massiest
massiness112810143massiness
massy104518963mass__y
mastic103119173masti_c
mastiche1547173mastiche
mastics112614783mastics
mastiff1538163mastiff
masting104325823masting
mastix152310513masti_x
mastixes1738253mastixes
mastlike1437863mastlike
mauve104013273ma__uve
mavie104722563ma_vi_e
maxixe1435223ma_xixe
message1037833message
messiah1246793messiah
messier93412923messier
messily12298813messily
messing103916393messing
midsize1946393midsize
miscite11314383miscite
misdrive1446683misdrive
misfile122611553misfile
misfire12229893misfire
misgave13298283misgave
misgiven14245903misgiven
misgives14329293misgives
mislie83219153misli_e
mislike132914833mislike
mislived14328783mislived
mislives132912153mislives
mismove1437083mismove
missies93423983missies
missiles103015083missiles
missing103619073missing
mission9312743mission
missis84417503missi_s
missises103513693missises
mistime11312613mistime
mossier94413813mossier
mossing103915423mossing
mosslike1435453mosslike
motive113112143m_otive
muskie123412543muski_e
muspike1536043muspike
mussier93314363mussier
mussily12279773mussily
mussing104015543mussing
naive85116213na__ive
native9613013na_tive
passade1039233passade
passage1039803passage
passe75525693pass__e
passee84522023pass_ee
passible1237693passible
passim10410283passi_m
passing104318423passing
passion9310883passion
passivate1445683passivate
passively1744613passively
passover13135533passover
pastie85525523pasti_e
pastime114611973pastime
pensive122610393pensive
plausive1344583plausive
plosive1236673plosive
rassle63813203rass_le
remissive1445773remissive
restive10315933restive
sassier73413233sassier
sassies74719263sassies
sassily1038723sassily
sassing84615553sassing
sessile739523sessile
shive114423423__shive
skive124614113__skive
suasive1037853suasive
swive115316193__swive
tardive1136893tardive
tasse54821843tass__e
tassies74918933tassies
tensive10269913tensive
visive1257873_visive
waive114214603wa__ive
wayside1435183wayside

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.1401276364.3
2DLD Change Limit1340272216.11021935.7
3Display Results2212210.0762907.9
 (SQL Overall)1786912216.32628247.1
 
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.