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

214 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
passive1223959(None) 
massive12289771massive
passives13228821passives
assize1538632_assize
cassine93817282cassine
dassie74615572dassi_e
impassive1644242impassive
jussive1734292jussive
lassie64917742lassi_e
missive122413142missive
passade1039232passade
passage1039802passage
passe75525692pass__e
passee84522022pass_ee
passible1237692passible
passim10410282passi_m
passing104318422passing
passion9310882passion
passivate1445682passivate
passively1744612passively
passover13135532passover
pastie85525522pasti_e
pastime114611972pastime
pensive122610392pensive
plausive1344582plausive
plosive1236672plosive
tassie66017022tassi_e
tussive1035302tussive
abusive1245283abusive
active11313743_active
alive85722513_a_live
alsike1047913_alsike
amusive1246253amusive
arrive91311793_arrive
arsine64021043_arsine
aside65122093_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
emissive1345923emissive
erosive1039203erosive
evasive1344663evasive
expansive2144393expansive
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
mashie11315933mashi_e
massage1039893massage
masse75125293mass__e
massier93615223massier
massif11412533massi_f
massifs1237743massifs
massing104318023massing
massively1744153massively
misgive13339033misgive
mislive122812693mislive
missile92815403missile
missives133212843missives
naive85116213na__ive
native9613013na_tive
nonpassive1553873nonpassive
omissive1345103omissive
paise75028333pa__ise
palsied102911303palsied
palsies94420273palsies
panpipe1034833panpipe
pansies94521983pansies
pantie84326473panti_e
pantile93918483pantile
parasite10314843parasite
pardie96021443pardi_e
pardine103616733pardine
pareve114613013pa_reve
parse75236993pars__e
parsing103819553parsing
partite9317133partite
parve109824853pa__rve
parvise124211693parvise
pase65346863pa_s__e
pashing135120513pashing
pass65239953pass___
passable12310633passable
passades1139203passades
passado1037053passado
passaged1236243passaged
passages1139513passages
passant9813943passant
passed94320943pass_ed
passel85117003pass_el
passels93913023passels
passer84721033pass_er
passerine1147083passerine
passers94717753passers
passes86030473pass_es
passings11409873passings
passions10310583passions
passivated1644143passivated
passivates1544963passivates
passivism1644263passivism
passivist1445993passivist
passivity1744103passivity
passkey1633563passkey
passovers14144753passovers
passus83610293pass_us
passuses1036773passuses
paste74932953pa_s_te
pastiche1546933pastiche
pastier94320383pastier
pasties94529813pasties
pastil85018323pasti_l
pastille1038943pastille
pastils94416173pastils
pastimes123611903pastimes
pastina93914593pastina
pasting103826553pasting
pastis84924323pasti_s
pastises103616053pastises
pasture9311463pasture
patine85328123pa_tine
patsies93919483patsies
pattie84020963patti_e
pause75021833paus__e
pausing103912813pausing
pave96133893pa___ve
pavise114714803pa_vise
pavisse12546813pavisse
pensile92713543pensile
pepsine11310603pepsine
piassava1342253piassava
piscine11610973piscine
pismire1135353pismire
pissing103914803pissing
plosives1335893plosives
popsie103013063popsi_e
positive1349993positive
posse74722273poss__e
possible1245813possible
postdive1445763postdive
postie84123963posti_e
potsie83916033potsi_e
poussie936623poussi_e
predive13511083predive
preside10715613preside
prossie91812963prossi_e
puslike1347563puslike
pussier93711993pussier
pussies93615693pussies
pusslike1434033pusslike
rassle63813203rass_le
restive10315933restive
sassier73413233sassier
sassies74719263sassies
sassily1038723sassily
sassing84615553sassing
sessile739523sessile
shive114423423__shive
skive124614123__skive
suasive1037853suasive
swive115316193__swive
tardive1136893tardive
tasse54821843tass__e
tassies74918933tassies
tensive10269913tensive
visive1257873_visive
waive114214603wa__ive
wayside1435183wayside

Search took 9 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.423422437.4
2DLD Change Limit1340272147.59317651.4
3Display Results2142140.0762815.8
 (SQL Overall)1786912148.09222082.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.