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

166 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
passkey163356(None) 
passkeys1742321passkeys
paisley1235552paisley
parsley1247802parsley
passe75525692pass_e_
passed94320942pass_ed
passee84522022pass_ee
passel85117002pass_el
passer84721032pass_er
passes86030472pass_es
pussley12375122pussley
asked106919313_a_sked
asker96418783_a_sker
askew12529413_a_skew
assay8710283_ass_ay
asses55629283_ass_es
asset55932263_ass_et
basked135218603ba_sked
basket125722913ba_sket
basses85428303bass_es
basset85225383bass_et
bassly114610073bass_ly
bassy1012917103bass__y
cakey145517273ca__key
casked134815513ca_sked
casket124820993ca_sket
casky144512683ca_sk_y
causey113513273caus_ey
darkey145212423da_rkey
dassie74615573dassie_
dassies84418663dassies
fakey155515423fa__key
gasket114417253ga_sket
gassed85217633gass_ed
gasser75017773gass_er
gasses75724783gass_es
gassier83812573gassier
gassily1137813gassily
gassy95514023gass__y
hassel95614213hass_el
hassle93711593hassle_
hassled11358303hassled
hassles103411693hassles
hawkey19507633ha_wkey
lackey154813353la_ckey
lasses64827593lass_es
lassie64917743lassie_
lassies74420103lassies
lassoed8408743lassoed
lassoer7379383lassoer
lassoes74613853lassoes
masked134316523ma_sked
maskeg13388693ma_skeg
masker124416103ma_sker
masse75125293mass_e_
massed94421323mass_ed
masses85028713mass_es
massier93615223massier
massy104518963mass__y
pacey126720283pa__cey
packed154822603pa_cked
packer144223403pa_cker
packet144726503pa_cket
packly17228333pa_ckly
paiked135113433pa_iked
paise75028333pais_e_
paisleys1333343paisleys
palfrey1533343palfrey
palsied102911303palsied
palsies94420273palsies
palsy105417463pals__y
pansies94521983pansies
pansy105717973pans__y
parked134425143pa_rked
parker124121373pa_rker
parley116718363pa_rley
parse75236993pars_e_
parsec105914483pars_ec
parsed96323893pars_ed
parser84822373pars_er
parses85534703pars_es
parsleys1335083parsleys
pase65346863pa_s_e_
paseo77022513pa_s_eo
pases75346503pa_s_es
pashed125923143pa_shed
pashes115828393pa_shes
pass65239953pass___
passably1537253passably
passade1039233passade
passades1139203passades
passado1037053passado
passage1039803passage
passaged1236243passaged
passages1139513passages
passant9813943passant
passels93913023passels
passerby1542503passerby
passers94717753passers
passim10410283pass_im
passing104318423passing
passion9310883passion
passive12239593passive
passively1744613passively
passives13228823passives
passless10247223passless
passover13135533passover
passus83610293pass_us
passuses1036773passuses
paste74932953pa_ste_
pasted94426903pa_sted
pastel85918713pa_stel
paster85734373pa_ster
pastes85233913pa_stes
pastie85525523pastie_
pastier94320383pastier
pasties94529813pasties
pastry114913033pa_stry
pasty105725053pa_s_ty
patsies93919483patsies
patsy105717203pats__y
pause75021833paus_e_
paused95114963paus_ed
pauser84415963paus_er
pauses84621473paus_es
pawky173810153pa_wk_y
pesky145911563p_esk_y
pessary1246873pessary
pigsney1342873pigsney
pinkey154314673p_inkey
pissed94816933piss_ed
pisser84416383piss_er
pisses84525083piss_es
plisky1533713plisk_y
pokey145318973p__okey
posse74722273poss_e_
posses85128803poss_es
posset84923253poss_et
punkey154011173p_unkey
pusley11379613p_usley
pusses84322843puss_es
pussier93711993pussier
pussies93615693pussies
pussleys13273173pussleys
pussly11407373puss_ly
pussy105614843puss__y
rassle63813203rassle_
rassled83310453rassled
rassles73513923rassles
sassaby1244003sassaby
sassed76116173sass_ed
sasses64124393sass_es
sassier73413233sassier
sassies74719263sassies
sassily1038723sassily
sassy85813813sass__y
tackey154613083ta_ckey
tasked114714643ta_sked
tasse54821843tass_e_
tassel66014773tass_el
tasses64826763tass_es
tasset65925313tass_et
tassie66017023tassie_
tassies74918933tassies
tissuey1033663tissuey
whiskey20445583whiskey

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.436409841.7
2DLD Change Limit1340271665.98322401.3
3Display Results1661660.0632634.9
 (SQL Overall)1786911666.48227567.3
 
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.