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

292 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
perusers1032880(None) 
peruser93511371peruser_
peruses94018161peruse_s
ceruses93716232ceruse_s
defusers12487362defusers
erasers74413942_erasers
parsers94118152par_sers
pausers94113222p_ausers
perchers153611522perchers
perfumers1683712perfumers
perfuses1358662perfuse_s
perjurers18224462perjurers
perses85428062per_se_s
perukes133210112peruke_s
perusals1047142perusals
peruse84016842peruse__
perused103112182peruse_d
pressers103215022pressers
prosers94219642p_rosers
pruners93710722p_runers
pursers93916092pur_sers
pursuers10376522pursuers
refusers11499272refusers
versers103813512ver_sers
xeruses143010752xeruse_s
abusers94710553_abusers
accusers12285903accusers
amusers94610193_amusers
apprisers1345053apprisers
arousers84810973arousers
aspersers11377243asper_sers
bemuses1139293bemuse_s
berserk1334913ber_serk
berserks1433993ber_serks
bruisers10307953_bruisers
brushers134210573_brushers
carousers1156733carousers
causers94014783_causers
censers94313903ce_nsers
cereuses1049243cereuse_s
cerises94722253cerise_s
cerumens1235763cerumens
ceruse83914523ceruse__
chousers134610183chousers
corulers1039763corulers
coursers104412293coursers
creasers103612813creasers
cruisers10438263_cruisers
cruses88127713_cruse_s
crusets93811043_crusets
crushers134010083_crushers
cursers94317153cur_sers
debasers11377903debasers
defuser115110503defuser_
defuses114814593defuse_s
delousers1044663delousers
deluders10156433deluders
delusters1035973delusters
denuders10165873denuders
deposers11359243deposers
deriders102411853deriders
derivers123811363derivers
devisers12339863devisers
dorsers83516293dor_sers
dousers84817273_dousers
dressers9359863dressers
druses75517253_druse_s
eluders8409903_eluders
eraser64216333_eraser_
erases64425403_erase_s
eroses65327053_erose_s
erses55826803_er_se_s
excusers1734443excusers
ferules103112723ferule_s
fetuses10310243fetuse_s
focusers13134373focusers
genuses83510883genuse_s
geysers1135703ge_ysers
greasers93410253greasers
grousers93810723grousers
herders113914123her_ders
housers104717813_housers
infusers11286143infusers
jerkers18287083jer_kers
jerseys1733243jer_seys
kerseys1433993ker_seys
kreuzers2132063kreuzers
leasers74717843le_asers
mercers114412773mer_cers
mergers103813423mer_gers
merises93421423merise_s
misusers10348073misusers
mousers95216443_mousers
musers84719093__musers
neguses837933neguse_s
neuters74212263ne_uters
nexuses1436743nexuse_s
nonusers8268003nonusers
nursers74311833nur_sers
overuses11312643overuse_s
paraders113113113paraders
pardners11269193pardners
parers85530743par__ers
pareses94718873parese_s
parises94827183parise_s
parkers133816873par_kers
parriers103612903parriers
parsecs11429913par_secs
parser84822373par_ser_
parses85534703par_se_s
partiers103514243partiers
partners102711133partners
partyers13277763partyers
parures9512693parure_s
passers94717753p_assers
paupers114311073p_aupers
pauser84415963p_auser_
pauses84621473p_ause_s
pavisers13387443pavisers
peachers153213843peachers
pearlers1039023pearlers
peases85229473pe_ase_s
peckers153312673pe_ckers
pedalers11239393pedalers
peddlers12298533peddlers
pedlers103013273pe_dlers
peelers93615593pe_elers
peepers113713673pe_epers
peers75130273pe___ers
peises84125043pe_ise_s
peloruses1145873peloruse_s
pelters93720313pe_lters
penises9318193penise_s
penners93414183pe_nners
pensees9311203pe_nsees
pensters103012123pensters
peoplers1237153peoplers
pepluses1287013pepluse_s
peppers103311443pe_ppers
percher143313423percher_
perches143717953perche_s
percuss1137163percus__s
percusses1346503percusses
percussors1452803percussors
perdues103511333perdue_s
perdures11289683perdure_s
peres76246643per__e_s
perfumer1574553perfumer_
perfumery1972373perfumery
perfumes1555893perfume_s
perfuse1247663perfuse__
perfused1445823perfuse_d
periderm1346803periderm
periderms1444993periderms
perigees1189493perigees
peripters1368123peripters
perisarc1245363perisarc
perisarcs1344093perisarcs
perishes13313753perishes
perjurer17285903perjurer_
perjures17268083perjure_s
perkier133813123perkier_
permutes1238713permute_s
perries93226603perrie_s
perse75429523per_se__
persisters1246273persisters
persons93717003per_sons
persuaders1343343persuaders
perter84422283per_ter_
pertness10310093pertness
perturbers1442633perturbers
pertusses1145383pertusses
pertussis1143323pertussis
peruke123210393peruke__
peruked14367883peruke_d
perusal939193perus_al
perusing11811063perusing
pervaders1544433pervaders
perverse1336103per_verse
pervert12315583per_vert
perverts1337523per_verts
pesters93827093pe_sters
peters86624593pe__ters
petters93722363pe_tters
pewters124113353pe_wters
phereses1348093pherese_s
phrases12711463phrase_s
piercers12316723pier_cers
pissers95014753p_issers
pleasers104010293pleasers
plexuses1734113plexuse_s
pluses83618073p_luse_s
poetisers1145303poetisers
poisers94214433p_oisers
porkers134314933por_kers
porters93722703por_ters
posers84223973p__osers
pourers93513673p_ourers
pouters94221863p_outers
praisers103410833praisers
prases84429023p_rase_s
praters94921643p_raters
prayers124212853p_rayers
preavers13910263preavers
preeners102712813preeners
prefers123713333p_refers
preggers12236833preggers
preluders1234423preluders
premiers122911653premiers
presets94216423p_resets
presser93717623presser_
presses93523153presse_s
pressors103212673pressors
presters103419003presters
presumers1336373presumers
preyers124412363p_reyers
pricers113915063p_ricers
priers84521193p_r_iers
primers114215673p_rimers
prisere9310943p_risere
priseres10310823p_riseres
prises84133173p_rise_s
prizers183911843p_rizers
probers113514573p_robers
propers113619033p_ropers
proser84223463p_roser_
proses84733473p_rose_s
prospers123012253p_rospers
provers123817793p_rovers
prudery1335243p_rudery
prudes94215443p_rude_s
pruner83413453p_runer_
prunes83419063p_rune_s
pryers115012243p_r_yers
pulers83820283p__ulers
pulsers94213153p_ulsers
purflers13216963purflers
purgers104714003pur_gers
purser85020473pur_ser_
purses84826373pur_se_s
pursuer9338893pursuer_
pursues94111373pursue_s
puses75532203p__use_s
pushers123814503p__ushers
rasers64526783__rasers
rebukers14435683rebukers
rebuses94915293rebuse_s
recuses94619463recuse_s
reducers1147263reducers
refuser104912783refuser_
refuses104918553refuse_s
refuters11449603refuters
reposers102911603reposers
repulsers1144713repulsers
rerises73525883rerise_s
resumers1038083resumers
reuses66025523re_use_s
revisers113511933revisers
risers64624783__risers
rousers75220133_rousers
ruers515019413__ru_ers
rulers64317093__rulers
ruses56136583__ruse_s
rushers103816103__rushers
securers1057153securers
seducers1145383seducers
seisers73816393se_isers
sergers83815633ser_gers
servers103214833ser_vers
teasers75317243te_asers
termers95414503ter_mers
terriers84210813terriers
terser67317823ter_ser_
thrusters1245313thrusters
trousers83910623trousers
trussers8348263_trussers
trusters83112243_trusters
uprisers10206773uprisers
uruses63616503_uruse_s
users55817573___users
uteruses837183uteruse_s
varuses10310623varuse_s
venuses103111413venuse_s
vergers114412623ver_gers
verniers11227843verniers
verser94516963ver_ser_
verses94223763ver_se_s
versets103913093ver_sets
viruses1039413viruse_s
xerosere1544723xerosere
xeroseres1644683xeroseres
xeroses143612823xerose_s

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 Filter1786911461620.1531167915.0
2DLD Change Limit1461622928.58017035.2
3Display Results2922920.1262317.5
 (SQL Overall)1786912928.85920170.6
 
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.