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

451 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
perukes13321011(None) 
peruke123210391peruke_
peruked14367881peruked
peruses94018161peruses
berakes134815772berakes
ceruses93716232ceruses
ferules103112722ferules
parures9512692parures
pekes114623562pe__kes
perches143717952perches
perdues103511332perdues
perdures11289682perdures
peres76246642per__es
perfumes1555892perfumes
perfuses1358662perfuses
perjures17268082perjures
perked134617682per_ked
perks115325802per_k_s
permutes1238712permutes
perries93226602perries
perses85428062per_ses
peruse84016842peruse_
perused103112182perused
peruser93511372peruser
perusers10328802perusers
prudes94215442p_rudes
prunes83419062p_runes
pukes114523022p__ukes
rebukes134210552rebukes
xeruses143010752xeruses
aerates74627483aerates
aeries64737783aer_ies
aerobes9311493aerobes
aerugos834923aerugos
aperies9423203aper_ies
apertures1146473apertures
bemuses1139293bemuses
berake124216083berake_
beraked144312433beraked
berates94126853berates
berimes115216643berimes
berks115423123ber_k_s
bermes106023003ber_mes
berries94423553berries
betakes134212523betakes
brakes124923123_brakes
brumes106417073_brumes
brutes86118683_brutes
bruxes154811023_bruxes
burkes124421313bur_kes
cerates95428233cerates
ceres75540013cer__es
cereuses1049243cereuses
cerises94722253cerises
cerites94823433cerites
certes84623083cer_tes
cerumen1147763cerumen
cerumens1235763cerumens
ceruse83914523ceruse_
crakes124921813_crakes
cruces105117543_cruces
crudes96218623_crudes
cruses88127713_cruses
cruxes154911563_cruxes
cukes115422093__cukes
deduces1168793deduces
defuses114814593defuses
defuzes20398303defuzes
dekes105224453de__kes
deludes91810643deludes
deluges9169263deluges
denudes91510043denudes
deputes104911783deputes
derates84028883derates
derbies103016053derbies
derides93420853derides
derives114017813derives
derries83124623derries
detrudes1036193detrudes
deuces94015513de_uces
drakes114715863_drakes
drupes94912653_drupes
druses75517253_druses
dukes105023473__dukes
educes94011953_educes
ekes86726603_e__kes
eludes75417683_eludes
elutes64020313_elutes
enures63919713_enures
epergnes1156713epergnes
erases64425403_erases
ernes55224813_er_nes
erodes74819883_erodes
eroses65327053_eroses
erses55826803_er_ses
eructs83610793_eructs
erugos7347343_erugos
erupts8348903_erupts
etudes73811603_etudes
evokes13459683_evokes
exudes143710363_exudes
feres86038183fer__es
ferlies103216693ferlies
ferries103521083ferries
ferrules1136163ferrules
ferulas103110753ferulas
ferule93413203ferule_
feruled11318413feruled
fetuses10310243fetuses
flukes135114193_flukes
genuses83510883genuses
gerunds935183gerunds
grues65721963_gru_es
grumes94415553_grumes
heaumes1237423heaumes
hercules1337633hercules
heredes11313133heredes
heres86245903her__es
heroes94923823her_oes
herpes115517323her_pes
herries104025073herries
hertzes1938293hertzes
jerked18479593jer_ked
jerker17369043jer_ker
jerkers18287083jer_kers
jerkies183411583jerkies
jerks166514893jer_k_s
jerries143817513jerries
jukes165319103__jukes
kermes124616123ker_mes
kernes104717523ker_nes
kerries113317913kerries
legumes1036633legumes
lemures938793lemures
leudes75314093le_udes
merces105720743mer_ces
merches144013763merches
mercies113817563mercies
merdes94518603mer_des
meres75143573mer__es
mergees104411233mergees
merges94122483mer_ges
merises93421423merises
merks114722403mer_k_s
merles85322763mer_les
neguses837933neguses
nerves94216193ner_ves
nervules1145013nervules
nervures1135123nervures
netsukes1242793netsukes
neuks96510863ne_uk_s
neumes83112623ne_umes
nexuses1436743nexuses
nukes95418123__nukes
operates10515403operates
opercules1345573opercules
overuses11312643overuses
papules112411573papules
parades104121463parades
parbakes1638343parbakes
parches143720003parches
pares77164483par__es
pareses94718873pareses
parges94529543par_ges
paries84742513par_ies
parises94827183parises
parkas125018023par_kas
parked134425133par_ked
parker124121373par_ker
parkers133816873par_kers
parks116134463par_k_s
parles86334393par_les
paroles95025883paroles
parries93925843parries
parses85534703par_ses
partakes1449923partakes
parties93230863parties
paruras9310533paruras
parure8312523parure_
pauses84621473p_auses
peaces106324083pe_aces
peaches144120053peaches
peages94321843pe_ages
peaked136117403pe_aked
peaks114825623pe_ak_s
peases85229473pe_ases
peavies122213393peavies
pebbles1337573pebbles
pecked155019103pe_cked
pecker144615363pe_cker
peckers153312673pe_ckers
pecks135724433pe_ck_s
peddles112913693peddles
pedes85327283pe__des
peeked134314573pe_eked
peeks115021113pe_ek_s
peerages1189883peerages
peeries93623023peeries
pees65257373pe___es
peeves113814873pe_eves
peewees1236803peewees
peises84125043pe_ises
peke105926203pe__ke_
pekoes124410423pe_koes
pelages10714613pelages
peles75738083pe__les
pelites93821993pelites
peloruses1145873peloruses
pelves114514663pe_lves
penates93321593penates
penes75839223pe__nes
penises9318193penises
pennies94218813pennies
pensees9311203pensees
penuches1536943penuches
penuckles1743243penuckles
penults937123penults
penuries10311663penuries
peones83821043pe_ones
peonies93620153peonies
peoples11312213peoples
pepluses1287013pepluses
percales12313783percales
perched154713233perched
percher143313423percher
perchers153611523perchers
percuss1137163percuss
percusses1346503percusses
perdie94718513perdie_
perdue93912633perdue_
perdure10379623perdure_
perdured12287383perdured
perdus93711273per_dus
pere66450263per__e_
perea75026443per__ea
pereons92815003pereons
perfume1446503perfume_
perfumed1654533perfumed
perfumer1574553perfumer
perfumers1683713perfumers
perfuse1247663perfuse_
perfused1445823perfused
perhaps1446123perhaps
perigee101113383perigee
perigees1189493perigees
periled10316303periled
perils84121853per_ils
perilunes1147143perilunes
perinea9313033perinea
periods10312243periods
periques1937653periques
peris75537073per__is
perishes13313753perishes
peritus9311803peritus
perjure16327963perjure_
perjured18286263perjured
perjurer17285903perjurer
perjurers18224463perjurers
perjuries1846483perjuries
perk106232843per_k__
perkier133813123perkier
perkiest143313243perkiest
perkish16258823per_kish
perky145319483per_k_y
perlites10316353perlites
permed115217343per_med
permits11314003permits
perms95524513per__ms
permute1138793permute_
permuted1336703permuted
pernods1038483pernods
perplex1836143perplex
perps95521483per__ps
perrons93115483perrons
perse75429523per_se_
persons93717003persons
perspex1834173perspex
persuades1245623persuades
perter84422283per_ter
pertest9317043per_test
pertness10310093pertness
perturbs1244363perturbs
pertusses1145383pertusses
perusal939193perusal
perusals1047143perusals
pervades1437343pervades
pervs105117373per__vs
pesades10310893pesades
pestles93217693pestles
petites93820203petites
petrales10312953petrales
pettles93916483pettles
pewees11311393pe_wees
peyotes1238483peyotes
phereses1348093phereses
phrases12711463phrases
pierces113411193pier_ces
pikakes1245823pikakes
pikes115031033p__ikes
pilules9510623pilules
piques1739093piqu_es
pirates93020323pirates
plexuses1734113plexuses
plumes104318133p_lumes
pluses83618073p_luses
pokes116133013p__okes
porches143815673porches
pores75849033por__es
porgies103017003porgies
porked134717623por_ked
porker124917543por_ker
porkers134314933por_kers
porkies133416493porkies
porks115124143por_k_s
prases84429023p_rases
prates84633163p_rates
praxes156215183p_raxes
prebakes1639003prebakes
precures12312903precures
prees75937173p_r_ees
preludes1137833preludes
premies113823063premies
prepubes1436053prepubes
prepuces1438583prepuces
presses93523153presses
presumes1239843presumes
prevues1239263prevues
prexes154915943p_rexes
prexies163415003prexies
prezes173614693p_rezes
prices104524543p_rices
prides94324183p_rides
pries74339533p_r_ies
primes104225263p_rimes
prises84133173p_rises
prizes173819813p_rizes
probes104119453p_robes
proles84627203p_roles
proses84733473p_roses
proves114322253p_roves
prude84615973p_rude_
prune75119633p_rune_
pruned93413113p_runed
pruner83413453p_runer
pruners93710723p_runers
prunus8399363p_runus
pubes94423403p__ubes
puces94924633p__uces
puke105025463p__uke_
puked124716223p__uked
pules74538813p__ules
purees84721683pur_ees
purfles122511843purfles
purges94421763pur_ges
purines94420763purines
purples112712823purples
purpures1276143purpures
purses84826373pur_ses
pursues94111373pursues
puses75532203p__uses
pyrenes123511223pyrenes
pyres105523883pyr__es
pyrexes19305833pyrexes
pyrites12812203pyrites
pyrones123113303pyrones
pyropes142210193pyropes
rakes94440353__rakes
rebuke124010123rebuke_
rebuked14438343rebuked
rebuker13407843rebuker
rebukers14435683rebukers
rebuses94915293rebuses
recuses94619463recuses
reduces10513343reduces
refuges115413373refuges
refuses104918553refuses
refutes104515723refutes
relumes9612513relumes
remakes134116173remakes
reputes94615963reputes
rerises73525883rerises
reroutes8312223reroutes
reruns66413743reru_ns
resumes9313373resumes
retakes113718863retakes
retunes76918403retunes
reuses66025523re_uses
revokes144212503revokes
revues9813903revu_es
rewakes144614983rewakes
rubes74928413__rubes
rues46044483__ru_es
rules55234253__rules
runes55530223__runes
ruses56136583__ruses
rykes125513033__rykes
secures9613163secures
seduces1069283seduces
segues7412073segu_es
serapes95218103serapes
serenes73222903serenes
seres55448893ser__es
serges74225963ser_ges
series64540973ser_ies
serines74229543serines
serries73925353serries
serums83916303seru_ms
serves94423653ser_ves
shrikes144412393shrikes
spherules1443823spherules
sporules1037703sporules
spruces113810503spruces
sprues84515763spru_es
strakes114218073strakes
strikes114719093strikes
strokes114316323strokes
tenues63816443tenu_es
tenures7412013tenures
terces83921413ter_ces
ternes65422903ter_nes
terries73425613terries
trikes105419493_trikes
trokes104019263_trokes
truces84916333_truces
trues54925323_tru_es
ukes86122813___ukes
uruses63616503_uruses
uteruses837183uteruses
varuses10310623varuses
velures1039093velures
venues95115203venu_es
venules104011483venules
venuses103111413venuses
verdures12247743verdures
verges104320173ver_ges
verites103822253verites
vermes115019143ver_mes
verses94223763ver_ses
verstes104014273verstes
verves124617883ver_ves
viruses1039413viruses
xeroses143612823xeroses
xeroxes13246443xeroxes
xerus12313333xeru__s
yerked14509373yer_ked
yerks125416563yer_k_s
yeuked14456233ye_uked
yeuks125110093ye_uk_s
yperites13310153yperites
zerks185113823zer_k_s
zeroes154314343zer_oes

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.186960704.3
2DLD Change Limit1340274518.31616116.8
3Display Results4514510.1532947.7
 (SQL Overall)1786914518.65520646.0
 
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.