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

219 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
passives1322882(None) 
passive12239591passive_
assizes1638452_assizes
cassines103116612cassines
cassises103811742cassises
dassies84418662dassi_es
jussives1833842jussives
lassies74420102lassi_es
massive12289772massive_
missives133212842missives
palsies94420272palsi_es
pansies94521982pansi_es
passades1139202passades
passages1139512passages
passes86030472pass__es
passings11409872passings
passions10310582passions
passivates1544962passivates
passively1744612passively
passivism1644262passivism
passivist1445992passivist
passover13135532passover
passovers14144752passovers
passuses1036772passuses
pasties94529812pasti_es
pastimes123611902pastimes
pastises103616052pastises
patsies93919482patsi_es
plosives1335892plosives
pussies93615692pussi_es
sassies74719262sassi_es
tassies74918932tassi_es
actives12311523_actives
alsikes1137263_alsikes
apsides103911303_apsides
arrives101311513_arrives
arsines73518813_arsines
ascites9312603_ascites
asides75118873_a_sides
aspires9612043_aspires
aspises9611643_aspises
asses55629283_ass__es
assigns836193_assigns
assists738473_assists
assize1538633_assize_
assumes967163_assumes
assures7611403_assures
basses85428303bass__es
bassinet10312843bassinet
bassinets1146323bassinets
bassists1037183bassists
bastiles10313353bastiles
bossies94116833bossi_es
brassies103613533brassi_es
capsizes2147203capsizes
captives1538623captives
cassavas1344803cassavas
cassenes103611293cassenes
cassias93514343cassi_as
cassinas103610643cassinas
cassine93817283cassine_
cassinos10309353cassinos
cassis84818853cassi__s
cissies94116153cissi_es
cursives1337103cursives
daisies84217093daisi_es
dassie74615573dassi_e_
datives11310073da_tives
daysides1335963daysides
dissaves1239413dissaves
easies64126633ea_si_es
falsies103515013falsi_es
farsides1237993farsides
fascines13310143fascines
gasses75724783gass__es
gassier83812573gassi_er
gassiest93212523gassi_est
gassiness10268313gassiness
gassings10438403gassings
glassies94012273glassi_es
glassines10278043glassines
gussies82813303gussi_es
hassiums1344273hassiums
hassles103411693hass_les
hessites1138613hessites
hissies103915823hissi_es
hussies103213293hussi_es
huswives1742933huswives
impassive1644243impassive_
jasmines1736623jasmines
jassids1586143jassi_ds
jussive1734293jussive_
lasses64827593lass__es
lassie64917743lassi_e_
lassis65216703lassi__s
lassoes74613853lass_oes
mashies12318253mashi_es
massages1159883massages
masses85028713mass__es
massier93615223massi_er
massiest103314423massi_est
massifs1237743massi_fs
massiness112810143massiness
massively1744153massively
mastixes1738253mastixes
misgives14329293misgives
mislives132912153mislives
missies93423983missi_es
missiles103015083missiles
missises103513693missises
missive122413143missive_
naives94914223na__ives
nasties73520493nasti_es
natives10310823na_tives
paddies113715723paddi_es
palsied102911303palsi_ed
pandies104224503pandi_es
panmixes1934913panmixes
panpipes1135173panpipes
panties94230933panti_es
pantiles103617153pantiles
pappies103214833pappi_es
parasites11313153parasites
paries84742513pa_ri_es
parises94827183pa_rises
parishes13314753parishes
parries93925843parri_es
parses85534703pars__es
parties93230863parti_es
parvises133911913parvises
pases75346503pa_s__es
pashes115828393pa_s_hes
passade1039233passade_
passadoes1245093passadoes
passados1146303passados
passage1039803passage_
passaged1236243passaged
passe75525693pass__e_
passed94320943pass__ed
passee84522023pass__ee
passel85117003pass__el
passels93913023pass_els
passer84721033pass__er
passerines1246163passerines
passers94717753pass_ers
passible1237693passible
passim10410283passi__m
passing104318423passi_ng
passion9310883passi_on
passivate1445683passivate
passivated1644143passivated
passiveness1646263passiveness
passivisms1743713passivisms
passivists1544003passivists
passivities1644903passivities
passivity1744093passivity
passkey1633563pass_key
passkeys1742323passkeys
passless10247223passless
passus83610293pass__us
pastes85233913pa_s_tes
pastiches1637453pastiches
pastie85525523pasti_e_
pastier94320383pasti_er
pastiest103319553pasti_est
pastilles1148703pastilles
pastils94416173pasti_ls
pastime114611973pastime_
pastinas103712153pastinas
pastiness112312353pastiness
pastis84924323pasti__s
pastries101517423pastries
pastures10311963pastures
patines95225763pa_tines
patties93425143patti_es
pauses84621473paus__es
paves104833923pa___ves
pavises125315493pa_vises
pavisses13397103pavisses
pensive122610393pensive_
pepsines1239883pepsines
piassavas1442173piassavas
pismires1235883pismires
pisses84525083piss__es
plausive1344583plausive_
plosive1236673plosive_
poesies93217403poesi_es
popsies112816463popsi_es
posies84431433p_osi_es
positives1459173positives
posses85128803poss__es
posties93128813posti_es
potsies93019483potsi_es
poussies1038113poussi_es
prelives13310383prelives
presides11414913presides
prissies101712003prissi_es
prossies101515223prossi_es
pusses84322843puss__es
pussier93711993pussi_er
pussiest102911753pussi_est
pusslies1036173pusslies
rassles73513923rass_les
sasses64124393sass__es
sassier73413233sassi_er
sassiest83413623sassi_est
sassiness8249333sassiness
shives124921413__shives
sissies73716603sissi_es
skives134113943__skives
swives123915183__swives
tansies74521243tansi_es
tasses64826763tass__es
tassie66017023tassi_e_
tussises835433tussises
tussive1035303tussive_
waives123714183wa__ives
waysides1544453waysides
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 Limit1461622197.36019859.0
3Display Results2192190.0932354.8
 (SQL Overall)1786912197.87622688.0
 
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.