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

355 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
pusleys1228623(None) 
pulleys12399141pulleys
pusley11379611pusley_
pussleys13273171pussleys
burleys12479672burleys
gulleys11438522gulleys
hurleys13407332hurleys
muleys11409642mu_leys
mulleys12299202mulleys
paisleys1333342paisleys
parleys125212372parleys
parsleys1335082parsleys
pulers83820282pu_lers
pules74538812pu_le_s
pullers93618482pullers
pullets94015162pullets
pulley113713402pulley_
pulsers94213152pulsers
pulses83818662pulse_s
punkeys16366492punkeys
purveys15615902purveys
puses75532202pus_e_s
pushers123814502pushers
pushes114621662pushe_s
pusses84322842pusse_s
pussley12375122pussley_
aisles64721143aisle_s
alleys95113303_alleys
auklets11298573auklets
baileys12388933baileys
barleys125011843barleys
budless1038873budless
buglers105115323buglers
bugles94822443bugle_s
bullets93516393bullets
burlers94120273burlers
burley114715753burley_
busboys14325023busboys
buses75936013bus_e_s
bushels124110713bushels
bushers124018803bushers
bushes115226113bushe_s
bushless1335813bushless
busies85525263busie_s
buskers133414083buskers
busses85023383busse_s
busters94724123busters
bustlers104210613bustlers
bustles93816323bustle_s
butlers94518053butlers
butles84423913butle_s
causeys12387223caus_eys
coseys115215813cos_eys
culets85518513cu_lets
cullays12347703cullays
cullers93418843cullers
cullets94015613cullets
curlers94218063curlers
curlews12387393curlews
cusecs10509153cus_ecs
cussers94213393cussers
cusses84522773cusse_s
cuteys11569973cu_teys
cutlers94216993cutlers
cutlets94113653cutlets
doyleys14384923doyleys
duelers83412053duelers
dulses73913653dulse_s
dusters84918353dusters
dustless9328343dustless
fleys117015603__fleys
foleys123810463_foleys
fuelers103912393fuelers
fugles104715783fugle_s
fullers103817373fullers
furlers104214223furlers
furless103210143furless
fusees95416403fus_ees
fuseless11237233fuseless
fusels94412453fus_els
fuses85628423fus_e_s
fussers104210813fussers
fusses94920553fusse_s
galleys11369713galleys
gasless8319013gasless
gleys96514853__gleys
guglets9369693guglets
guiles73919283guile_s
gules64831043gu_le_s
gullets84013713gullets
gulley104213163gulley_
gumless10228273gumless
gunless8299633gunless
gurneys11406463gurneys
gushers113512503gushers
gushes104719033gushe_s
gussets837443gussets
gustless9287683gustless
gutless82610713gutless
haslets102510863haslets
henleys1334843henleys
hoseys124614003hos_eys
hueless1058823hueless
hullers103616263hullers
hunkeys17386193hunkeys
hurlers103714323hurlers
hurley125012523hurley_
hushes124718593hushe_s
huskers143510033huskers
hustlers11349203hustlers
hustles103414173hustle_s
isles54220563_isle_s
islets64513083_islets
juleps1535623ju_leps
justers143815723justers
justles143311433justle_s
leys76430183___leys
lisles63416283lisle_s
lullers73213353lullers
lushes94022743lushe_s
lusters73921433lusters
medleys13115333medleys
mislays12349243mislays
mooleys1236863mooleys
moseys114711703mos_eys
motleys1235683motleys
mules75034293mu_le_s
muley104819283mu_ley_
mullens93611313mullens
mullers93217303mullers
mullets93614783mullets
mulley114013453mulley_
murreys12367323murreys
muscles11310563muscle_s
musers84719093mus_ers
muses75134303mus_e_s
mushers124016433mushers
mushes114124563mushe_s
muskegs14285003muskegs
muskets13258633muskets
muslins9312213muslins
mussels9419843mussels
musses84624783musse_s
mustees94614923mustees
musters94522493musters
nucleus956573nucleus
nutlets74111253nutlets
opuses84012243opus_e_s
ousels64815273ous_els
ousters74122773ousters
outlays102610903outlays
outlets73616363outlets
padles95221113padle_s
paisley1235553paisley_
pales75753803p_ale_s
palets85122313p_alets
pallets93919303pallets
parlays123910453parlays
parles86334393parle_s
parley116718353parley_
parsley1247793parsley_
paseos88015813pas_eos
pases75346503pas_e_s
pashes115828393pashe_s
passels93913023passels
passers94717753passers
passes86030473passe_s
passkeys1742323passkeys
passless10247223passless
pastels95215183pastels
pasters94531733pasters
pastes85233913paste_s
pastless102411203pastless
pausers94113223paus_ers
pauses84621473paus_e_s
peaveys15324063peaveys
pedlers103013273pedlers
peelers93615593peelers
pegless1038053pegless
peles75738083p_ele_s
pellets94014783pellets
pesters93827093pesters
pestles93217693pestle_s
phoneys15437143phoneys
piglets103311793piglets
pigsneys1442003pigsneys
piles74742613p_ile_s
pileus84514943p_ileus
pinkeys16378213pinkeys
piolets93513193piolets
pishers123815753pishers
pishes114722103pishe_s
pissers95014753pissers
pisses84525083pisse_s
pistes85325633piste_s
plays106320773p__lays
pleas75627033p__leas
plebs95814583p__lebs
plews105415353p__lews
ploys105816593p__loys
plugless1133863plugless
pluses83618073plus_e_s
plushes124313673plushe_s
plusses93510693plusse_s
pogeys124110353p_ogeys
pokeys15529513p_okeys
poleis86018353p_oleis
polers84225643p_olers
poles75351003p_ole_s
poleyn1157323p_oleyn
poleyns1236113p_oleyns
pollees93215333pollees
pollens93713303pollens
pollers93420023pollers
polys105718763p_ol_ys
poolers94217423poolers
posers84223973pos_ers
poses74642763pos_e_s
posies84431433posie_s
posoles9314883posole_s
posses85128803posse_s
possess9419113possess
possets94212773possets
posters93927993posters
preys105717783p__reys
prolegs10379993prolegs
proles84627203prole_s
pubes94423403pu_be_s
publics13207143publics
puces94924633pu_ce_s
puckers153514673puckers
puddlers12298683puddlers
puddles113613823puddle_s
puffers15349203puffers
pugrees10218523pugrees
puisnes937423puisne_s
pukes114523023pu_ke_s
pule65040953pu_le__
puled84926523pu_le_d
puler74826623pu_le_r
pulis74225603pu_l_is
pulled94322193pulle_d
puller83820813pulle_r
pullet84026333pulle_t
pulls74425053pu_l_ls
pullups1134233pullups
pulpers114612283pulpers
pulpless12224953pulpless
pulps95116483pu_l_ps
pulpy124612363pu_lpy_
puls65437563pu_l__s
pulsars9358913pulsars
pulse74219973pulse__
pulsed94013723pulse_d
pulser84215193pulse_r
pumelos11196093pumelos
pummels13236543pummels
pumpers133113673pumpers
pumpless14236373pumpless
pungles104013713pungle_s
punkers133714853punkers
punkey154011173punkey_
punners94114233punners
punnets9409263punnets
punsters103310583punsters
punters93617033punters
puppets10317013puppets
purees84721683pu_rees
purely114013613purely_
purflers13216963purflers
purfles122511843purfle_s
purgers104714003purgers
purges94421763purge_s
purled94520743purle_d
purlieus1034633purlieus
purlins93415423purlins
purls74723353purl__s
purples112712823purple_s
pursers93916093pursers
purses84826373purse_s
pursuers10376523pursuers
pursues94111373pursue_s
purvey14559573purvey_
pushed125017463pushe_d
pusher114318283pushe_r
pushups1433653pushups
pushy134614353pus_hy_
puslike1347563puslike
puss64830133pus___s
pussies93615693pussies
pusslies1036173pusslies
pussly11407373pussly_
pussy105614843pus_sy_
pustules1038443pustule_s
putlogs1065083putlogs
puttees93612913puttees
putters94219183putters
putzes174212523putze_s
puzzlers18295143puzzlers
puzzles17318973puzzle_s
queleas1636723queleas
queys17398363qu__eys
ridleys11145783ridleys
rubles83921703ruble_s
rulers64317093ru_lers
rules55234253ru_le_s
runless72810423runless
runlets73310773runlets
ruses56136583rus_e_s
rushees103311953rushees
rushers103816103rushers
rushes94724363rushe_s
russets738163russets
rustlers8339853rustlers
rustles73416413rustle_s
rustless83510233rustless
slays85723683__slays
sleds64418853__sleds
slews86220353__slews
smileys12336323smileys
spurreys13364593spurreys
sublets92616703sublets
sudsless944353sudsless
sumless92611123sumless
sunless73013693sunless
surreys10489433surreys
surveys13357573surveys
susliks1136443susliks
susses64221053susse_s
sutlers73116973sutlers
tousles74113933tousle_s
tugless837383tugless
tules54532793tu_le_s
tulles63218893tulle_s
turkeys1434523turkeys
tushes94319473tushe_s
tuskers113710033tuskers
tuskless1234213tuskless
tussehs10395563tussehs
tussers74313563tussers
tusses64921243tusse_s
tussles737833tussle_s
unlays93810493_unlays
unless62413073_unless
upsets8409683ups_ets
upsteps1133743upsteps
useless7188423_useless
users55817573_us_ers
uses44931113_us_e_s
ushers94415533_ushers
usneas638333_usneas
valleys13407483valleys
volleys13316643volleys
wusses93314893wusse_s
yules84521583yu_le_s

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.1561145455.1
2DLD Change Limit1340273557.15618729.3
3Display Results3553550.1262817.5
 (SQL Overall)1786913557.43824024.1
 
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.