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

456 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
peskier1331911(None) 
peakier134411441peakier
peckier153910521peckier
perkier133813121perkier
pestier94317401pestier
beakier134012162beakier
boskier13309172boskier
duskier12409422duskier
esker94412982_esk_er
geekier12286392geekier
huskier14369752huskier
jerkier18407272jerkier
leakier114010992leakier
meshier123410852meshier
messier93412922messier
muskier134312722muskier
pastier94320382pastier
pawkier16236612pawkier
peatier94017232peatier
pecker144615362peck_er
peppier10268322peppier
peskiest142610162peskiest
peskily1635082peskily
pester84827592pes_ter
pettier94213612pettier
pickier153912972pickier
pockier153911602pockier
pokier124914632p_okier
porkier133712342porkier
punkier133512792punkier
pushier123611092pushier
pussier93711992pussier
reekier113111122reekier
riskier1138422riskier
skier95119592__skier
testier74015642testier
zestier163010222zestier
aerier64823153ae_rier
ashier94714833_ashier
asker96418783_ask_er
balkier134111983balkier
barkier133814483barkier
beadier103513913beadier
beaker125520693beak_er
beamier113411943beamier
beefier12329093beefier
beerier93613023beerier
belier84423563be_lier
bendier103111413bendier
beshiver1634483beshiver
bestir8311163besti_r
bosker123813653bosk_er
bossier93712423bossier
brakier133812363brakier
bulkier134111513bulkier
bushier123712813bushier
busier85219723bus_ier
busker125517833busk_er
bustier93916153bustier
cakier123115243_cakier
cashier123713323cashier
cheekier1735103cheekier
chestier1387423chestier
chokier1638043chokier
cockier154013623cockier
corkier133114303corkier
cosier84423753cos_ier
creakier14328333creakier
cushier123610833cushier
dashier114311183dashier
decker135215993deck_er
decrier102713553decrier
deedier93011593deedier
defier105118653de_fier
deifier113013123deifier
denier74420693de_nier
dernier83011943dernier
descrier1157623descrier
desire7415303des_ire
desirer8310783desirer
deskmen1435023deskmen
despiser1136343despiser
destrier9311823destrier
dewier104013463de_wier
dickier143512453dickier
dinkier123411503dinkier
dishier113613403dishier
dorkier122810023dorkier
dossier83711693dossier
dressier956863dressier
duckier143911793duckier
dustier83814133dustier
easier64218463_easier
edgier8469723_edgier
eelier64216463_eelier
eerier64320023_eerier
elmier839813_elmier
enskied1234653enskied
enskies1138573enskies
envier939673_envier
eskar9457453_esk_ar
eskers105312223_esk_ers
espied9359773_espied
espies83716803_espies
ester54727713_es_ter
feistier1136193feistier
fennier10339253fennier
fernier103110813fernier
fester94723513fes_ter
fishier13359853fishier
flakier143910203flakier
fleshier1435603fleshier
flukier14397853flukier
folkier14359043folkier
forkier144311583forkier
freakier15246483freakier
friskier1535193friskier
funkier14349983funkier
fussier103610673fussier
fustier104213933fustier
gassier83812573gassier
gawkier15326523gawkier
gemmier12337383gemmier
germier10309543germier
gunkier12369553gunkier
gushier113110073gushier
gustier83813863gustier
hastier103916623hastier
headier113212953headier
heavier13429423heavier
heckler16278573heckler
hedgier12367873hedgier
heftier1337203heftier
hempier14319003hempier
herbier1239593herbier
hinkier143610793hinkier
hissier103410503hissier
hokier134214033_hokier
hookier143811673hookier
hosier94219613hos_ier
hulkier14328973hulkier
hunkier144512143hunkier
husker134212703husk_er
huskies143212073huskies
ickier12439913_ickier
inkier104013773_inkier
jerker17369043jerk_er
jerkies183411583jerkies
jester134319153jes_ter
jettier14358693jettier
jokier17618753_jokier
junkier18339493junkier
kickier12349053kickier
kier86526803___kier
kinkier10319433kinkier
kookier10398283kookier
lakier104716273_lakier
lankier113711633lankier
larkier113711523larkier
leadier83212723leadier
leafier10329833leafier
leaker104620073leak_er
learier73415663learier
leavier10319993leavier
ledgier9458493ledgier
leerier73111503leerier
leggier9368233leggier
lesser63514853les_ser
levier94013873le_vier
luckier133811533luckier
lustier73813503lustier
masker124416103mask_er
massier93615223massier
mealier93015903mealier
measlier1036013measlier
meatier93214613meatier
meeker12359983meek_er
merrier92612303merrier
metier83517693me_tier
milkier133411163milkier
mirkier13319053mirkier
mistier93418713mistier
mossier94413813mossier
muckier153411473muckier
murkier133110263murkier
mushier123813583mushier
muskie123412533muskie_
muskies133614663muskies
mussier93314353mussier
mustier94017953mustier
nastier74115293nastier
necker124012793neck_er
needier84010623needier
nerdier83110353nerdier
nervier10298833nervier
nester64124183nes_ter
nestler73510443nestler
nettier74211813nettier
newsier10147223newsier
nonskier1235983nonskier
nosier63716323nos_ier
oakier104011393_oakier
osier53518013_os_ier
pacier105018683p_acier
packer144223403pack_er
palier85023563p_alier
pallier94417163pallier
palmier113312173palmier
panier84425503p_anier
pannier93613353pannier
pappier103511593pappier
parker124121373park_er
parrier93717653parrier
partier93520713partier
passer84721033pas_ser
paster85734373pas_ter
pastie85525523pastie_
pasties94529813pasties
peacher144216073peacher
peachier1548623peachier
peaked136117403peak_ed
peakiest143512993peakiest
peaking144317683peaking
peakish16268873peakish
pearler9310363pearler
pearlier1037313pearlier
pearter9412743pearter
peavies122213393peavies
pebblier1453263pebblier
pecked155019103peck_ed
peckers153312673peck_ers
peckiest162711393peckiest
pecking164017783pecking
peckish18227293peckish
pedaler103410693pedaler
pedalier1137603pedalier
peddler113210493peddler
pedler93614613pe_dler
peeked134314573peek_ed
peeking144414953peeking
peeler83517383pe_eler
peeper103614803pe_eper
peer66238353pe___er
peerie83617893peerie_
peeries93623023peeries
peke105926203pe_k_e_
pekes114623563pe_k_es
pekin111514423pe_ki_n
pekins121812233pe_kins
pekoe114612363pe_koe_
pekoes124410423pe_koes
pelter83321623pe_lter
penciler1237103penciler
penner84616663pe_nner
pennies94218813pennies
penster92811953penster
peonies93620153peonies
peopler1138073peopler
pepper93512943pe_pper
peptizer21236473peptizer
percher143313423percher
perdie94718513perdie_
perked134617683perk_ed
perkiest143313243perkiest
perkily1637803perkily
perking143716453perking
perkish16258823perkish
perries93226603perries
perspire1246663perspire
perter84422283pe_rter
peruser93511373peruser
pesade9311103pesade_
pesades10310893pesades
peskiness15216523peskiness
pesky145911563pesk__y
pesterer102412703pesterer
pesters93827093pes_ters
pestiest103018413pestiest
pestle83215843pestle_
pestled102711433pestled
pestles93217693pestles
peter74427593pe__ter
petter83924773pe_tter
pewter114013673pe_wter
phonier122710633phonier
pickeer153710113pickeer
picker144422173pick_er
pier66035293p___ier
piggier113510003piggier
piker115622843p_ik_er
pinier84024693p_inier
pinker125322443pink_er
pinkie124414273pinkie_
pinkies133818263pinkies
pipier104913983p_ipier
pisher114317753pis_her
pismire1135353pismire
pisser84416383pis_ser
pithier123010293pithier
pitier84019823p_itier
plashier1337613plashier
platier93716293platier
plier75221283p__lier
pliskie1394543pliskie_
pliskies1475973pliskies
pluckier16295073pluckier
plumier113510043plumier
plunkier14305323plunkier
plushier1375193plushier
podgier11338723podgier
poesies93217403poes_ies
poker115122883p_ok_er
pokies125921333p_okies
porker124917543pork_er
porkies133416493porkies
pornier93413123pornier
poser75128773pos__er
posher115018163pos_her
posies84431433pos_ies
poster84129173pos_ter
postie84123963postie_
posties93128813posties
pottier93516493pottier
poutier93215323poutier
poxier153812113p_oxier
premier113515633premier
preppier1156643preppier
presager1138443presager
presider11410423presider
presser93717623pres_ser
prester93519623pres_ter
presumer1247583presumer
prettier1069043prettier
pricier113313113pricier
prickier16368143prickier
prier75027763p__rier
prissier10157873prissier
privier122910453privier
prosier93817483prosier
pucker143817633puck_er
pudgier11377723pudgier
puffier1547973puffier
puggier11309383puggier
pulpier1148623pulpier
punier84519223p_unier
punker123718823punk_er
punkie123513613punkie_
punkies134216803punkies
punnier93511263punnier
pursier94012753pursier
purtier93214093purtier
pusher114318283pus_her
pussies93615693pussies
puttier93314503puttier
quakier20239203quakier
raspier93110633raspier
readier83117423readier
reedier83815303reedier
reefier102912553reefier
reeker103715593reek_er
reifier103414523reifier
relier65826183re_lier
rentier73618223rentier
replier94214973replier
rescuer939033rescuer
resider84615803resider
respire9411543respire
rester63832433res_ter
resumer9410113resumer
risker105414493risk_er
rockier134911883rockier
rookier114012383rookier
rosier64221263ros_ier
rushier103411973rushier
rustier74416363rustier
sarkier113413313sarkier
sassier73413233sassier
seamier93114633seamier
sedgier9399043sedgier
seedier83513633seedier
seeker103615363seek_er
seepier92912013seepier
selkie102811693selkie_
selkies113513353selkies
sexier13310683se_xier
shakier143411153shakier
shier85428943__shier
siker95326033__siker
silkier114411643silkier
sissier73711363sissier
skied104417753__skied
skiers104713693__skiers
skies95026833__skies
skiey125012893__skiey
skirr94810543__skirr
skiver134612103__skiver
sleekier1245573sleekier
slier54827243__slier
smokier1356703smokier
snakier112810003snakier
sneakier1245143sneakier
sparkier14298023sparkier
speaker133311213speak_er
speedier1146623speedier
spendier1147143spendier
spier75728033__spier
spikier13369983spikier
spookier14175493spookier
spunkier14235813spunkier
suckier133613973suckier
sulkier113811963sulkier
tackier133712523tackier
talkier114011843talkier
tastier711817093tastier
tearier73815613tearier
techier1269243techier
teenier72611143teenier
tekkie934203tekkie_
tekkies1035943tekkies
tentier73815923tentier
terrier73414963terrier
tester64227153tes_ter
tressier847963tressier
tusker104212193tusk_er
tweakier1533143tweakier
vastier103613203vastier
vealier102712173vealier
veinier10269583veinier
verier94620963ve_rier
vernier102711273vernier
vesper1138083ves_per
wackier16369733wackier
washier133611153washier
waspier12259053waspier
weaker134015443weak_er
weaklier1534263weaklier
wearier103613283wearier
webbier1445423webbier
wedgier12428273wedgier
weedier113810623weedier
weenier103210803weenier
weepier12319273weepier
wennier10318603wennier
weskit1338343weski_t
weskits1434743weskits
wester94222893wes_ter
whelkier1833253whelkier
wispier12249403wispier
wonkier1437423wonkier
wussier10408083wussier
yeastier1135393yeastier
yester93417983yes_ter
yolkier14336123yolkier
yuckier16358533yuckier
yukkier13263893yukkier
zester153617793zes_ter

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340274568.04616657.6
3Display Results4564560.1702682.4
 (SQL Overall)1786914568.37221343.9
 
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.