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

155 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
pusslies103617(None) 
pussies93615691puss_ies
gussies82813302guss_ies
hussies103213292huss_ies
poussies1038112pouss_ies
pusses84322842puss__es
pussier93711992puss_ier
pussiest102911752puss_iest
pussley12375122pussl_ey
pussleys13273172pussleys
pusslike1434032pusslike
tussles737832tussl_es
wussies103411082wuss_ies
bossies94116833boss_ies
bubblies1166773bubblies
bullies94121893bu_llies
busbies113011693bu_sbies
busies85525263bu_s_ies
busses85023383buss__es
bustles93816323bustl_es
bustlines11207353bustlines
cissies94116153ciss_ies
cullies94419963cu_llies
cusses84522773cuss__es
dassies84418663dass_ies
fusilier1135413fusilier
fusiliers1243703fusiliers
fusses94920553fuss__es
fussier103610673fuss_ier
fussiest112910493fuss_iest
gullies84717313gu_llies
gussie72910153guss_ie_
gussied9267193guss_ied
hassles103411693hassl_es
hissies103915823hiss_ies
hurlies103315333hu_rlies
huskies143212073hu_skies
hustles103414173hustl_es
jussives1833843jussives
justles143311433justl_es
lassies74420103lass_ies
mislies92922283_mislies
missies93423983miss_ies
missiles103015083missiles
mudslides1343223mudslides
mueslis935493muesli_s
muhlies1238933mu_hlies
muscles11310563muscl_es
muskies133614663mu_skies
muslins9312213mu_slins
musses84624783muss__es
mussier93314353muss_ier
mussiest103112933muss_iest
outflies11310143outflies
outlies72421993ou_tlies
palsies94420273pals_ies
pansies94521983pans_ies
parslied1137803parslied
passades1139203passades
passages1139513passages
passes86030473pass__es
passives13228823passives
passless10247223passless
passuses1036773passuses
pasties94529813p_asties
pastries101517423pastries
patsies93919483pats_ies
pessaries11108653pessaries
pestles93217693pestl_es
pigsties1139783pigsties
pisolites1149383pisolites
pisses84525083piss__es
pissoirs1044693pissoirs
plies74526513p___lies
pliskies1475973pliskies
plussages1243293plussages
plusses93510693pluss__es
poesies93217403poes_ies
polies84034583p__olies
popsies112816463pops_ies
posies84431433p_os_ies
posoles9314883posol_es
posses85128803poss__es
posties93128813p_osties
potsies93019483pots_ies
poussie936623pouss_ie_
preslices1338203preslices
prissies101712003prissies
prossies101515223prossies
prosties101421193prosties
publics13207143pu_blics
puddles113613823puddl_es
puddlier1234213puddlier
puddliest1343683puddliest
puggries12166383puggries
puisnes937423puis_nes
pules74538813pu__l_es
pulis74225603pu__li_s
pulsates1048813pulsates
pulses83818663pu__lses
pungles104013713pungl_es
punkies134216803pu_nkies
punties94520783pu_nties
puppies103212613pu_ppies
purfles122511843purfl_es
purifies13311923purifies
purities10316283purities
purlieu938143pu_rlieu
purlieus1034633pu_rlieus
purlines103514053pu_rlines
purlins93415423pu_rlins
purples112712823purpl_es
purses84826373purs__es
pursier94012753purs_ier
pursiest102812123purs_iest
purslanes1145523purslanes
pursues94111373purs_ues
pursuits1045043pursuits
puses75532203pu_s__es
pushes114621663pu_s_hes
pushier123611093pu_shier
pushiest133211713pu_shiest
pushpins1543343pushpins
pusley11379613pu_sl_ey
pusleys12286233pu_sleys
puslike1347563pu_slike
pussly11407373pussl__y
pussytoes1441753pussytoes
pustules1038443pustules
putsches1535313putsches
putties94420023pu_tties
puzzles17318973puzzl_es
rassles73513923rassl_es
russifies1245443russifies
rustles73416413rustl_es
sassies74719263sass_ies
sissies73716603siss_ies
sullies74122223su_llies
supplies1268823supplies
susliks1136443su_sliks
susses64221053suss__es
tassies74918933tass_ies
tushies10312163tu_shies
tusses64921243tuss__es
tussis6379953tuss_i_s
tussises835433tussises
tussle637143tussl_e_
tussled835413tussl_ed
tussling935823tussling
tussores8316533tussores
uglies7412323_u_glies
usuries7510633_usuries
wusses93314893wuss__es
wussier10408083wuss_ier
wussiest11268663wuss_iest

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.1701051123.5
2DLD Change Limit1461621558.19017846.4
3Display Results1551550.0602583.3
 (SQL Overall)1786911558.42021222.2
 
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.