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

434 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
peruke12321039(None) 
peruked14367891peruked
perukes133210111perukes
peruse84016841peruse
berake124216082berake
ceruse83914522ceruse
ferule93413202ferule
parure8312522parure
peke105926202pe__ke
perdie94718512perdie
perdue93912632perdue
perdure10379622perdure
pere66450262per__e
perfume1446502perfume
perfuse1247662perfuse
perjure16327962perjure
perk106232842per_k_
perked134617692per_ked
perks115325802per_ks
perky145319482per_ky
permute1138792permute
perse75429522per_se
perused103112202perused
peruser93511372peruser
peruses94018162peruses
prude84615972p_rude
prune75119632p_rune
puke105025462p__uke
rebuke124010122rebuke
aerate64830553aerate
aerie54634603aer_ie
aerobe8412403aerobe
aerugo735803aerugo
apelike13310533apelike
aperture1046393aperture
belike124616283belike
bemuse1038943bemuse
beraked144312433beraked
berakes134815773berakes
berate84729023berate
berime105317333berime
berk105929843ber_k_
berks115423123ber_ks
berme96022943ber_me
betake124512703betake
brake116025343_brake
broke116019783_broke
brume95817983_brume
brute75321783_brute
burke115122763bur_ke
cerate84829463cerate
cere66741473cer__e
cerise84822043cerise
cerite84724873cerite
cerumen1147763cerumen
ceruses93716233ceruses
crake114823523_crake
crude86018573_crude
cruse75726103_cruse
cuke105824983__cuke
curule83614123curule
deduce1079253deduce
defuse105712723defuse
defuze19487843defuze
deke95228763de__ke
delude81910673delude
deluge8189403deluge
deluxe14197303deluxe
demure9311533demure
denude8169353denude
depute94512303depute
derate74531233derate
dere56845903der__e
deride84420033deride
derive103817043derive
detrude936083detrude
deuce84517493de_uce
drake104918303_drake
drupe85012993_drupe
druse64817663_druse
duke95628103__duke
educe84313453_educe
eerie55228533eer_ie
eke75630093_e__ke
elude64517623_elude
elute54822573_elute
enure53520223_enure
epergne1046143epergne
erase54925493_erase
ere36352773_er__e
erne46727433_er_ne
erode64520993_erode
erose55727283_erose
eruct74022353_eruct
erugo6369853_erugo
erupt74220063_erupt
etude63612303_etude
evoke12478853_evoke
exude134010293_exude
fere76342233fer__e
feriae95618603feriae
ferine96422583ferine
ferlie92814053ferlie
ferrule1035863ferrule
ferula93011173ferula
ferulae10309603ferulae
feruled11318423feruled
ferules103112723ferules
fluke125016893_fluke
gerund836163gerund
grue55825713_gru_e
grume86218163_grume
heaume1137543heaume
here76447103her__e
hermae115314473hermae
jejune1233763jejune
jerk154920133jer_k_
jerked18479593jer_ked
jerker17369043jer_ker
jerks166514893jer_ks
jerky196712423jer_ky
juke154721663__juke
kerne94718223ker_ne
legume936913legume
leke85527403le__ke
merde84320123mer_de
mere67244443mer__e
merge84523693mer_ge
mergee94018143mergee
merk106027943mer_k_
merks114722403mer_ks
merle75824373mer_le
nebule848753nebule
nerve86617373ner_ve
nervule1044943nervule
nervure1034973nervure
netsuke1142673netsuke
neuk87416603ne_uk_
neuks96510863ne_uks
neume74414403ne_ume
nuke85920753__nuke
operate9615733operate
opercule1245283opercule
operose939433operose
overuse10310923overuse
papule102212133papule
parade94720643parade
parae76335703par_ae
parbake1538353parbake
pardee93922023pardee
pardie96021443pardie
pare66760843par__e
pareve114613013pareve
parge85831853par_ge
park105237493par_k_
parka115120883par_ka
parked134425143par_ked
parker124121373par_ker
parks116134463par_ks
parle75836163par_le
parole84425253parole
parse75236993par_se
partake1339643partake
parura8310593parura
parures9512693parures
parve109824853par_ve
pause75021833p_ause
peace95026083pe_ace
peage84723573pe_age
peak106535203pe_ak_
peaked136117403pe_aked
peaks114825623pe_aks
peaky145718153pe_aky
pealike131211273pealike
pease75231113pe_ase
pebble1238003pebble
peck125730683pe_ck_
pecked155019103pe_cked
pecker144615363pe_cker
pecks135724433pe_cks
pecky165515093pe_cky
pedate93117763pedate
peddle103512823peddle
pee56066513pe___e
peek106031433pe_ek_
peeked134314583pe_eked
peeks115021113pe_eks
peerage1089803peerage
peerie83617893peerie
peeve104915253pe_eve
peewee11311973peewee
peglike14136773peglike
peise75825773pe_ise
pekes114623563pe__kes
pekoe114612363pe_koe
pelage9515363pelage
pele65539553pe__le
pelite84323003pelite
pence94924453pe_nce
penile82219603penile
pennae84314033pennae
penne75423853pe_nne
pensee8417313pensee
penuche1435943penuche
penuckle1643263penuckle
penult8314653penult
penury1148103penury
people10310193people
per56353093per___
percale11314093percale
perch124518833per_ch
perched154713243perched
percher143313423percher
perches143717953perches
percuss1137163percuss
perdu84216273per_du
perdues103511333perdues
perdured12287403perdured
perdures11289683perdures
perdus93711273perdus
perdy115417333per_dy
perea75026443per_ea
pereia85217983pereia
pereon83517453pereon
peres76246643per_es
perfumed1654543perfumed
perfumer1574553perfumer
perfumes1555893perfumes
perfumy1763933perfumy
perfused1445843perfused
perfuses1358663perfuses
peri65636973per__i
perigee101113393perigee
peril75425953per_il
periled10316323periled
perils84121853perils
perilune1046983perilune
perinea9313033perinea
period9314983period
perique1837523perique
peris75537073per_is
perish114619063perish
periti8319953periti
perjured18286273perjured
perjurer17285903perjurer
perjures17268083perjures
perjury19244253perjury
perkier133813123perkier
perlite9317323perlite
perm85834633per__m
permed115217353permed
permit10321683permit
perms95524513per_ms
permuted1336713permuted
permutes1238713permutes
pernio8513143pernio
pernod9310453pernod
peroxy1838253peroxy
perp89029893per__p
perplex1836153perplex
perps95521483per_ps
perries93226603perries
perron83216623perron
perry105222713per_ry
perses85428063perses
person83517873person
perspex1834183perspex
persuade1145853persuade
pert66759323per__t
perter84422283perter
pertly115312553pertly
perturb1146003perturb
perusal939193perusal
perusers10328803perusers
perv97224813per__v
pervade1337023pervade
pervs105117373per_vs
pesade9311103pesade
pesky145911563pe_sky
pestle83215843pestle
petite84320653petite
petrale9312623petrale
pettle84116053pettle
pewee10319973pe_wee
peyote1139853peyote
phrase11109903phrase
pierce104010393pier_ce
pikake11115803pikake
pike106335213p__ike
pilule8411123pilule
pique16410173piqu_e
pirate82322883pirate
pleurae945863pleurae
plume94819463p_lume
poke105335363p__oke
pore66451263por__e
pork106929683por_k_
porked134717623por_ked
porker124917543por_ker
porks115124143por_ks
porky145019333por_ky
porose84818743porose
prase76128753p_rase
prate75135983p_rate
prebake1539093prebake
precure11312553precure
pree67044733p_r_ee
prelude1038013prelude
premie103617993premie
premune1138933premune
prepuce1337833prepuce
prerace11414123prerace
prese75228383p_rese
presume11310303presume
prevue1179163prevue
price93725413p_rice
pride84724733p_ride
prime96525603p_rime
prise74632613p_rise
prize164718943p_rize
probe94320813p_robe
prole74527793p_role
prone75332623p_rone
prose75835123p_rose
prove104823193p_rove
prudes94215443p_rudes
pruned93413113p_runed
pruner83413453p_runer
prunes83419063p_runes
pruta7314243p_ruta
puce85127883p__uce
puerile9310093puerile
puked124716223p__uked
pukes114523023p__ukes
pule65040953p__ule
pure65543333p__ure
puree74632843pur_ee
purfle112511183purfle
purge85324603pur_ge
purine85321893purine
purple102712683purple
purpure1195993purpure
purse76028893pur_se
pursue84512253pursue
pyre94925553pyr__e
pyrene113210733pyrene
pyrite11913313pyrite
pyrone112714473pyrone
pyrope132810533pyrope
rake84841573__rake
rebuked14438343rebuked
rebuker13407843rebuker
rebukes134210553rebukes
recuse85519163recuse
reduce9713253reduce
refuge105312613refuge
refuse94817513refuse
refute95515703refute
relume8313273relume
remake124016113remake
repute84716093repute
rerise64325633rerise
rerose63320853rerose
reroute7313963reroute
rerun58722153reru_n
reruns66413743reruns
resume8313783resume
retake104718533retake
retune69121953retune
retuse66617223retuse
reuse56025363re_use
revoke135216243revoke
revue81114453revu_e
rewake135218463rewake
rewoke1339521223rewoke
rube65532013__rube
rude55632783__rude
rue35549263__ru_e
rule49938423__rule
rune45236303__rune
ruse45938933__ruse
ryke115616403__ryke
secure8513533secure
seduce9610023seduce
segue6314413segu_e
serape84818413serape
sere46153473ser__e
serene63522353serene
serge64727473ser_ge
serine65432673serine
serum75223473seru_m
serums83916303serums
serve85425963ser_ve
shrike134513243shrike
spherule1343843spherule
sporule937273sporule
spruce103910873spruce
sprue74717633spru_e
strake104017393strake
strike105619733strike
stroke105116173stroke
tenure6311613tenure
terce75721843ter_ce
terete6319333terete
terne56426153ter_ne
terrae62915213terrae
terse55026823ter_se
trike95320163_trike
troke94821053_troke
truce75118693_truce
true46725853_tru_e
uke75727293___uke
velure939773velure
venue84918213venu_e
venule94411763venule
verdure11287773verdure
verge93419843ver_ge
verite94323443verite
verse84723583ver_se
verste94515633verste
verve115417723ver_ve
were76238333wer__e
xerus12313333xeru_s
xeruses143010753xeruses
yerk116222083yer_k_
yerked14509373yer_ked
yerks125416563yer_ks
yeuk116015473ye_uk_
yeuked14456233ye_uked
yeuks125110093ye_uks
yeuky15547033ye_uky
yperite1249893yperite
zerk175319253zer_k_
zerks185113823zer_ks

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 Filter1786911127160.436409841.7
2DLD Change Limit1127164347.40615219.6
3Display Results4344340.3431265.3
 (SQL Overall)1786914348.18521831.5
 
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.