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

197 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
passade103923(None) 
passades1139201passades
passado1037051passado
passage1039801passage
cascade12118602cascade
massage1039892massage
palisade1145832palisade
parade94720642pa_rade
parkade1437582parkade
passable12310632passable
passadoes1245092passadoes
passados1146302passados
passaged1236242passaged
passages1139512passages
passant9813942passant
passe75525692pass__e
passed94320942passed_
passee84522022pass_ee
passive12239592passive
pesade9311102p_esade
abrade9313053_abrade
alcade91111513_alcade
ansae55720973_ansa_e
ansate64517863_ansate
arcade91013643_arcade
aside65122093_a_side
assai5711543_assa_i
assail6610153_assail
assais6711963_assais
assay8710283_assa_y
assayed1135593_assayed
assayer1035573_assayer
assays977903_assays
assize1538633_assize
assuage835683_assuage
assume897563_assume
assure6610773_assure
asswage1144673_asswage
aubade939223_aubade
ballade104012563ballade
brassage1145283brassage
camisade1374823camisade
cascaded14135703cascaded
cascades13128553cascades
casease939323casease
caseate9314783caseate
cassaba1145663cassaba
cassata938143cassata
cassava1255003cassava
cassene93111543cassene
cassine93817283cassine
crusade1036053crusade
dassie74615573dass_ie
dayside1236173dayside
dissave1139413dissave
dissuade1065933dissuade
facade1238803fa_cade
farside1138603farside
fissate103010033fissate
fossae95510373fossa_e
fossate10388603fossate
gambade1336383gambade
gassed85217633gassed_
glissade1043193glissade
hassle93711593hass_le
hassled11358303hassled
hastate10313913hastate
jassid1467223jassid_
jassids1586143jassids
lassie64917743lass_ie
lassoed8408743lassoed
manmade1237963manmade
massa75518923massa__
massacre1244743massacre
massaged1236753massaged
massager1136873massager
massages1159883massages
massas85116463massa_s
masse75125293mass__e
massed94421323massed_
massive12289773massive
message1037833message
mismade12129353mismade
package16128013package
paesan85114093paesa_n
paesani9348683paesani
paesano9338793paesano
paesans93312693paesans
paisa76021073paisa__
paisan84417073paisa_n
paisana94010233paisana
paisano9429513paisano
paisans93614753paisans
paisas84317493paisa_s
paise75028333pais__e
palace104516923pa_lace
palate84226793pa_late
paleae84820293palea_e
paleate94120003paleate
palisaded1343563palisaded
palisades1245613palisades
palmate113215233palmate
palpate113213923palpate
palsied102911303palsied
panada94113053pa_nada
pancake1536673pancake
paraded114014263pa_raded
parader103914863pa_rader
parades104121473pa_rades
parae76335713pa_ra_e
parbake1538353parbake
parkades1538273parkades
parsable12311693parsable
parse75236993pars__e
parsed96323893parsed_
partake1339643partake
pascal10812373pasca_l
pascals11610013pascals
pase65346863pa_s__e
pasha105417183pasha__
pashadom1643843pashadom
pashas115117063pasha_s
pashed125923143pashed_
pass65239953pass___
passably1537253passably
passband1344773passband
passbands1453983passbands
passel85117003pass_el
passels93913023passels
passer84721033pass_er
passers94717753passers
passes86030473pass_es
passible1237693passible
passim10410283pass_im
passing104318423passing
passion9310883passion
passivate1445683passivate
passives13228823passives
passkey1633563passkey
passover13135533passover
passus83610293pass_us
passuses1036773passuses
pasta76624533pasta__
pastas85422873pasta_s
paste74932953pa_s_te
pasted94426903pasted_
pastie85525523pa_stie
pastime114611973pastime
pasture9311463pasture
pausal81511963pausa_l
pause75021833paus__e
paused95114963paused_
pavane114113443pa_vane
pawnage1335873pawnage
paygrade1543593paygrade
persuade1145853persuade
pervade1337023pervade
pesades10310903p_esades
pessary1246873pessary
piassaba1242433piassaba
piassava1342253piassava
pissant91012503pissant
pissed94816933pissed_
plussage1143223plussage
pomade113611333p_omade
posada937163p_osada
posse74722273poss__e
postage103214853postage
prebade12310283prebade
prefade1339013prefade
premade12311443premade
presage10312293presage
presale9416353presale
preside10715613preside
psoae74411623p_soa_e
pulsate9510233pulsate
rassle63813203rass_le
rassled83310453rassled
repassage1243123repassage
respade1039573respade
saccade12107033saccade
sade55544483___sade
sassaby1244003sassaby
sassed76116173sassed_
sausage847193sausage
shade95125583__shade
spade84423323__spade
stade64825303__stade
tasse54821843tass__e
tassie66017023tass_ie
torsade837593torsade
tsade64311123__tsade
vassal979243vassa_l
vassals1057953vassals
wassail1056133wassail
wastage11109253wastage
wayside1435183wayside

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271977.22018563.3
3Display Results1971970.0762592.1
 (SQL Overall)1786911977.71923149.5
 
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.