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 “passkeys” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
passkeys174232(None) 
passkey1633561passkey_
paisleys1333342paisleys
parsleys1335082parsleys
passels93913022pass_els
passers94717752pass_ers
passes86030472pass_e_s
passless10247222passless
pussleys13273172pussleys
askers105915403_a_skers
assays977903_ass_ays
asses55629283_ass_e_s
assess65710463_ass_ess
assets65617663_ass_ets
baskets135111833ba_skets
basses85428303bass_e_s
bassets96414823bass_ets
bassness1096743bassness
caskets133910173ca_skets
causeys12387223caus_eys
darkeys15356533da_rkeys
dassies84418663dassie_s
gaskets12348153ga_skets
gassers84714633gass_ers
gasses75724783gass_e_s
hassels104311013hass_els
hassles103411693hassle_s
hawkeys20414703ha_wkeys
lackeys16458263la_ckeys
lasses64827593lass_e_s
lassies74420103lassie_s
lassoers8338513lassoers
lassoes74613853lassoe_s
maskegs14375413ma_skegs
maskers133913833ma_skers
masses85028713mass_e_s
massless10277113massless
packers153818893pa_ckers
packets155114773pa_ckets
paisley1235553paisley_
palfreys1642003palfreys
palsies94420273palsie_s
pansies94521983pansie_s
parkers133816873pa_rkers
parleys125212373pa_rleys
parsecs11429913pars_ecs
parsers94118153pars_ers
parses85534703pars_e_s
parsley1247793parsley_
paseos88015813pa_s_eos
pases75346503pa_s_e_s
pashes115828393pa_she_s
passades1139203passades
passados1146293passados
passages1139513passages
passe75525693pass_e__
passed94320943pass_e_d
passee84522023pass_e_e
passel85117003pass_e_l
passer84721033pass_e_r
passings11409873passings
passions10310583passions
passives13228823passives
passovers14144753passovers
passus83610293pass__us
passuses1036773passuses
pastels95215183pa_stels
pasters94531733pa_sters
pastes85233913pa_ste_s
pasties94529813pastie_s
pastless102411203pastless
pastness102510503pastness
patsies93919483patsie_s
pausers94113223paus_ers
pauses84621473paus_e_s
pigsneys1442003pigsneys
pinkeys16378213p_inkeys
pissers95014753piss_ers
pisses84525083piss_e_s
pokeys15529513p__okeys
posses85128803poss_e_s
possess9419113poss_ess
possets94212773poss_ets
punkeys16366493p_unkeys
pusleys12286233p_usleys
pusses84322843puss_e_s
pussies93615693pussie_s
pussley12375123pussley_
rassles73513923rassle_s
sasses64124393sass_e_s
sassies74719263sassie_s
tassels74510853tass_els
tasses64826763tass_e_s
tassets75012773tass_ets
tassies74918933tassie_s
whiskeys21353383whiskeys

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162968.04618165.8
3Display Results96960.0462087.0
 (SQL Overall)178691968.24821664.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.