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

413 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
peruser9351137(None) 
peruse84016841peruse_
perused103112191perused
perusers10328801perusers
peruses94018161peruses
ceruse83914522ceruse_
ceruses93716232ceruses
defuser115110502defuser
eraser64216332_eraser
parser84822372par_ser
pauser84415962p_auser
percher143313422percher
perfumer1574552perfumer
perfuse1247662perfuse_
perfused1445832perfused
perfuses1358662perfuses
perjurer17285902perjurer
perkier133813122perkier
perse75429522per_se_
perses85428062per_ses
perter84422282per_ter
peruke123210392peruke_
peruked14367892peruked
perukes133210112perukes
perusal939192perusal
presser93717622presser
proser84223462p_roser
pruner83413452p_runer
purser85020472pur_ser
pursuer9338892pursuer
refuser104912782refuser
terser67317822ter_ser
verser94516962ver_ser
xeruses143010752xeruses
abuser85413683_abuser
accuser11347933accuser
aerier64823153aer_ier
amuser84712623_amuser
appriser1246783appriser
arouser74514423arouser
asperser10408303asper_ser
bemuse1038943bemuse_
bemused1236713bemused
bemuses1139293bemuses
berserk1334913ber_serk
bruiser9349573_bruiser
brusher123813003_brusher
brusker13437853_brusker
carouser1068853carouser
causer84117783_causer
censer84516583ce_nser
cereuses1049243cereuses
cerise84822043cerise_
cerises94722253cerises
cerumen1147763cerumen
chouser125212943chouser
coruler9311713coruler
courser94114803courser
creaser94415743creaser
cruder95612383_cruder
cruiser93410433_cruiser
cruse75726103_cruse_
cruses88127713_cruses
cruset84425093_cruset
crusher124412323_crusher
curser84721473cur_ser
debaser103510413debaser
defuse105712723defuse_
defused125211093defused
defusers12487363defusers
defuses114814593defuses
delouser936363delouser
deluder9168333deluder
deluster936903deluster
demurer1037873demurer
denser74115193de_nser
denuder9167603denuder
deposer104011843deposer
derider93214973derider
deriver114213913deriver
dernier83011943dernier
deviser114212393deviser
dorser74819183dor_ser
douser75621633_douser
dresser83611953dresser
druse64817663_druse_
druses75517253_druses
eerier64320023eer_ier
eluder73712213_eluder
erase54925493_erase_
erased74816753_erased
erasers74413943_erasers
erases64425403_erases
erose55727273_erose_
eroses65327053_eroses
erses55826803_er_ses
excuser1635813excuser
fernier103110823fernier
ferule93413203ferule_
feruled11318423feruled
ferules103112723ferules
fetuses10310243fetuses
focuser12155783focuser
genuses83510883genuses
germier10309543germier
geyser1036513ge_yser
greaser83913083greaser
grouser84513693grouser
herbier1239593herbier
herder104516463her_der
houser95322283_houser
infuser10298323infuser
jerker17369043jer_ker
jerkier18407273jerkier
jersey1636333jer_sey
kersey1336793ker_sey
kreuzer2032353kreuzer
leaser65322673le_aser
lesser63514853le_sser
mercer105214203mer_cer
merer75126233mer__er
merger95016483mer_ger
merises93421423merises
merrier92612303merrier
misuser93210443misuser
mouser85822443_mouser
muser76024123__muser
neguses837933neguses
nerdier83110353nerdier
nervier10298833nervier
neuter63713793ne_uter
nexuses1436743nexuses
nonuser7299143nonuser
nurser64314503nur_ser
obtuser9134453obtuser
operose939433operose_
overuse10310923overuse_
overused1249443overused
overuses11312643overuses
parader103914863parader
pardner10239473pardner
parer75839903par__er
pareses94718883pareses
parises94827183parises
parker124121373par_ker
parrier93717653parrier
parse75236993par_se_
parsec105914483par_sec
parsed96323893par_sed
parsers94118153par_sers
parses85534703par_ses
partier93520713partier
partner92811393partner
partyer12337873partyer
parure8312523parure_
parures9512693parures
passer84721033p_asser
pauper103511943p_auper
pause75021833p_ause_
paused95114963p_aused
pausers94113223p_ausers
pauses84621473p_auses
paviser12489093paviser
peacher144216073peacher
peakier134411443peakier
pearler9310373pearler
pearlier1037323pearlier
pearter9412743pearter
pease75231113pe_ase_
peasen84815963pe_asen
peases85229473pe_ases
peatier94017233peatier
pecker144615363pe_cker
peckier153910523peckier
pedaler103410693pedaler
peddler113210493peddler
pedler93614623pe_dler
peeler83517383pe_eler
peeper103614803pe_eper
peer66238353pe___er
peise75825773pe_ise_
peised94817683pe_ised
peises84125043pe_ises
peloruses1145873peloruses
pelter83321623pe_lter
penises9318193penises
penner84616663pe_nner
pensee8417313pe_nsee
penster92811953penster
peopler1138083peopler
pepluses1287023pepluses
pepper93512943pe_pper
peppier10268323peppier
perched154713243perched
perchers153611523perchers
perches143717953perches
percuss1137163percus_s
percussed1444803percussed
percusses1346503percusses
percussor1342913percussor
perdie94718513perdie_
perdue93912633perdue_
perdues103511333perdues
perdure10379623perdure_
perdured12287403perdured
perdures11289683perdures
perdus93711273perdus__
pere66450263per__e_
perea75026443per__ea
peres76246643per__es
perfume1446503perfume_
perfumed1654543perfumed
perfumers1683713perfumers
perfumery1972383perfumery
perfumes1555893perfumes
periderm1346803periderm
perigee101113393perigee
periled10316323periled
perinea9313033perinea
peripter1278753peripter
peris75537073peris__
perisarc1245363perisarc
perish114619063peris_h
perished14310083perished
perishes13313753perishes
perjure16327963perjure_
perjured18286273perjured
perjurers18224463perjurers
perjures17268083perjures
perked134617693per_ked
perks115325803perks__
permed115217353per_med
perms95524513perms__
permute1138793permute_
permuted1336713permuted
permutes1238713permutes
perplex1836153perplex
perps95521483perps__
perries93226603perries
persister1146833persister
person83517873per_son
perspex1834183perspex
persuader1244263persuader
pertest9317043pertest
perturber1343153perturber
pertusses1145383pertusses
perusals1047143perusals
perusing11811063perusing
pervader1444863pervader
pervert12315583per_vert
pervs105117373pervs__
peskier13319113peskier
pester84827593pe_ster
pestier94317403pestier
peter74427593pe__ter
petter83924773pe_tter
pettier94213613pettier
pewter114013673pe_wter
phereses1348093phereses
phrase11109903phrase_
phrased1387383phrased
phrases12711463phrases
piercer11337773pier_cer
pisser84416383p_isser
pleaser93912343pleaser
plexuses1734113plexuses
pluses83618073p_luses
plusher124010383p_lusher
poetiser1037313poetiser
poiser84217243p_oiser
porker124917543por_ker
porkier133712343porkier
pornier93413133pornier
porose84818743porose_
porter84224413por_ter
poser75128773p__oser
pourer84516043p_ourer
pouter83923983p_outer
praiser93413943praiser
prase76128753p_rase_
prases84429023p_rases
prater84825353p_rater
prayer114815293p_rayer
preaver121011613preaver
preciser123411663preciser
preener93114833preener
prefer113813203p_refer
preluder1135733preluder
premier113515633premier
prese75228383p_rese_
preset84430983p_reset
pressed103317313pressed
pressers103215023pressers
presses93523153presses
pressor93512883pressor
prester93519623prester
presumer1247583presumer
preyer114413733p_reyer
pricer103918293p_ricer
prier75027763p_r_ier
primer105118683p_rimer
prise74632613p_rise_
prised94322203p_rised
prisere9310943p_risere
prises84133173p_rises
prizer174714883p_rizer
prober104516073p_rober
proper104319953p_roper
prose75835123p_rose_
prosed94921093p_rosed
prosers94219643p_rosers
proses84733473p_roses
prosier93817483p_rosier
prosper114012193p_rosper
prouder10310383prouder
prover113819723p_rover
prower114218123p_rower
prude84615973p_rude_
prudery1335243p_rudery
prudes94215443p_rudes
prune75119633p_rune_
pruned93413113p_runed
pruners93710723p_runers
prunes83419063p_runes
pryer104415313p_r_yer
puler74826623p__uler
pulser84215193p_ulser
purer75127903p__urer
purfler12248733purfler
purger94717233pur_ger
purpler11289273purpler
purse76028893pur_se_
pursed95220883pur_sed
pursers93916093pur_sers
purses84826373pur_ses
pursier94012753pursier
pursue84512253pursue_
pursued10388133pursued
pursuers10376523pursuers
pursues94111373pursues
purtier93214093purtier
puses75532203p__uses
pusher114318283p__usher
raser55633413__raser
rebuker13407843rebuker
rebuses94915293rebuses
recuse85519163recuse_
recused104714423recused
recuses94619463recuses
reducer1059003reducer
refuse94817513refuse_
refused115114443refused
refusers11499273refusers
refuses104918553refuses
refuter104312193refuter
reposer93715333reposer
repulser1035803repulser
rerise64325633rerise_
rerisen73613643rerisen
rerises73525883rerises
rerose63320843rerose_
resumer9410113resumer
retuse66617223retuse_
reuse56025363re_use_
reused75419563re_used
reuses66025523re_uses
reviser104114663reviser
riser55431053__riser
rouser65224083_rouser
ruder65320543__ruder
ruer46127563__ru_er
ruler54923343__ruler
ruse45938933__ruse_
ruses56136583__ruses
rusher94019653__rusher
securer958253securer
seducer1056503seducer
seiser65318343se_iser
serener73415763serener
serer55935513ser__er
serger73819743ser_ger
server94917713ser_ver
sparser94311483spar_ser
sprucer11317683sprucer
teaser65421523te_aser
tenser64919433te_nser
termer85717253ter_mer
terrier73414963terrier
terse55026823ter_se_
thruster1135793thruster
trouser73812473trouser
truer54916643_tru_er
trusser74010263_trusser
truster73114313_truster
upriser9218763upriser
uruses63616503_uruses
user45023003___user
uteruses837183uteruses
varuses10310623varuses
venuses103111413venuses
verger104315703ver_ger
verier94620963ver_ier
vernier102711273vernier
verse84723583ver_se_
versed104515513ver_sed
versers103813523ver_sers
verses94223763ver_ses
verset94327323ver_set
viruses1039413viruses
worser95117523wor_ser
xerosere1544733xerosere
xeroses143612823xeroses
xerus12313333xerus__

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.406440125.6
2DLD Change Limit1340274136.92019368.1
3Display Results4134130.1562647.4
 (SQL Overall)1786914137.48223882.8
 
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.