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

182 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
passades113920(None) 
passade1039231passade_
passadoes1245091passadoes
passados1146301passados
passages1139511passages
cascades13128552cascades
massages1159882massages
palisades1245612palisades
parades104121462pa_rades
parkades1538272parkades
passado1037052passad_o
passage1039802passage_
passaged1236242passaged
passes86030472pass__es
passives13228822passives
passuses1036772passuses
pesades10310902p_esades
abrades10312073_abrades
alcades101011473_alcades
apsides103911303_apsides
arcades101113193_arcades
asides75118873_a_sides
assails769093_assails
assais6711963_assa_is
assayed1135593_assayed
assayer1035573_assayer
assayers1144843_assayers
assays977903_assa_ys
asses55629283_ass__es
assizes1638453_assizes
assuages936273_assuages
assumes967163_assumes
assures7611403_assures
asswages1255053_asswages
aubades1038753_aubades
ballades114211643ballades
basses85428303bass__es
brassages1245263brassages
camisades1474963camisades
cascade12118603cascade_
cascaded14135703cascaded
caseases10410473caseases
caseates10313713caseates
cassabas1245733cassabas
cassatas1036683cassatas
cassavas1344803cassavas
cassenes103611293cassenes
cassines103116613cassines
cassises103811743cassises
crusades1146333crusades
dassies84418663dass_ies
daysides1335963daysides
dipsades1246493dipsades
dissaves1239413dissaves
dissuades1166243dissuades
facades1339033fa_cades
farsides1237993farsides
gambades1435863gambades
gasses75724783gass__es
glissades1143313glissades
hassles103411693hass_les
jassids1586143jassid_s
lasses64827593lass__es
lassies74420103lass_ies
lassoes74613853lass_oes
maenades1137473maenades
massacres1344693massacres
massage1039893massage_
massaged1236753massaged
massager1136873massager
massagers1245513massagers
massas85116463massa__s
masses85028713mass__es
messages1138233messages
naiades838213na_iades
packages17138733packages
paesanos10296703paesanos
paesans93312693paesa_ns
paisanas10288873paisanas
paisanos10337553paisanos
paisans93614753paisa_ns
paisas84317493paisa__s
palaces114216463pa_laces
palates93624943pa_lates
palisade1145833palisade_
palisaded1343563palisaded
palpates122613063palpates
palsies94420273pals_ies
panadas103312213pa_nadas
pancakes1637073pancakes
pansies94521983pans_ies
parade94720643pa_rade_
paraded114014263pa_raded
parader103914863pa_rader
paraders113113113pa_raders
parados103816053pa_rados
parbakes1638343parbakes
parkade1437583parkade_
parses85534703pars__es
partakes1449923partakes
pascals11610013pasca_ls
pases75346503pa_s__es
pashadom1643843pashadom
pashadoms1743453pashadoms
pashas115117063pasha__s
pashes115828393pa_s_hes
passable12310633passable
passably1537253passably
passant9813943passa_nt
passbands1453983passbands
passe75525693pass__e_
passed94320943pass__ed
passee84522023pass__ee
passel85117003pass__el
passels93913023pass_els
passer84721033pass__er
passers94717753pass_ers
passings11409873passings
passions10310583passions
passivates1544963passivates
passive12239593passive_
passkey1633563pass_key
passkeys1742323passkeys
passless10247223passless
passover13135533passover
passovers14144753passovers
passus83610293pass__us
pastas85422873pasta__s
pastes85233913pa_s_tes
pasties94529813pa_sties
pastimes123611903pastimes
pastises103616053pastises
pastries101517423pastries
pastures10311963pastures
patsies93919483pats_ies
pauses84621473paus__es
pavanes123612653pa_vanes
pawnages1435313pawnages
paxwaxes1942053paxwaxes
paygrades1643623paygrades
persuades1245623persuades
pervades1437353pervades
pesade9311103p_esade_
pessaries11108663pessaries
piassabas1342323piassabas
piassavas1442173piassavas
pissants1097363pissants
pisses84525083piss__es
pleiades1145753pleiades
plussages1243293plussages
pomades123711733p_omades
posadas1037193p_osadas
posses85128803poss__es
postages112815323postages
prefades1439533prefades
presages11312203presages
presales10315263presales
presides11414913presides
pulsates1048813pulsates
pusses84322843puss__es
pussies93615693puss_ies
pusslies1036173pusslies
rassles73513923rass_les
repassages1343053repassages
respades1139853respades
saccades13137253saccades
sades65239893___sades
sassabies1144153sassabies
sasses64124393sass__es
sassies74719263sass_ies
sausages937003sausages
shades105924533__shades
spades94222583__spades
stades74626243__stades
tasses64826763tass__es
tassies74918933tass_ies
torsades937213torsades
tsades74310993__tsades
vassals1057953vassa_ls
wassails1145953wassails
wastages12109753wastages
waysides1544453waysides

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.420425454.8
2DLD Change Limit1461621826.84621350.0
3Display Results1821820.0762394.7
 (SQL Overall)1786911827.34224338.2
 
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.