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

132 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
perfumes155589(None) 
perfume1446501perfume_
perfumed1654541perfumed
perfumer1574551perfumer
perfumers1683711perfumers
perfuses1358661perfuses
perdues103511332perdu_es
perdures11289682perdures
perfumery1972382perfumery
perfumy1763932perfum_y
perfuse1247662perfuse_
perfused1445832perfused
perjures17268082perjures
permutes1238712permutes
perukes133210112per_ukes
peruses94018162per_uses
presumes1239842presumes
apertures1146473apertures
berhymes1843803berhymes
berimes115216643ber_imes
bermes106023003ber__mes
brumes106417073_br_umes
cereuses1049243cereuses
ceriums1139473cerium_s
cerumen1147763cer_umen
cerumens1235763cer_umens
ceruses93716233cer_uses
defames132812253de_fames
defuses114814593de_fuses
defuzes20398303de_fuzes
deplumes1334943deplumes
effuses1335903_effuses
exhumes1934323_exhumes
ferrules1136163ferrules
ferrums1265983ferrum_s
ferules103112723fer_ules
fumes105224703___fumes
furfures1445663furfures
grumes94415553_gr_umes
heaumes1237423he_aumes
hercules1337633hercules
kermes124616133ker__mes
legumes1036633le_gumes
nervules1145013nervules
nervures1135123nervures
neumes83112623ne__umes
opercules1345573opercules
parures9512693par_ures
pennames12287793pennames
peplumed1543043peplumed
peplums13145503peplum_s
pepluses1287023pepluses
percales12313803percales
perches143717953per_ches
percuss1137163percu_ss
percusses1346503percusses
perdue93912633perdu_e_
perdure10379623perdure_
perdured12287403perdured
perdus93711273perdu__s
peres76246643per___es
perfects15107353perfects
perfidies1546603perfidies
performed17155303performed
performer16145133performer
performers17164103performers
performs1547483performs
perfumeries1852793perfumeries
perfuming1784053perfuming
perfusates1543993perfusates
perigees1189503perigees
perilunes1147163perilunes
periques1937653periques
perishes13313753perishes
perjure16327963perjure_
perjured18286273perjured
perjurer17285903perjurer
perjurers18224463perjurers
perjuries1846493perjuries
perlites10316363perlites
permed115217353per__med
perms95524513per__m_s
permute1138793permute_
permuted1336713permuted
perries93226603per_ries
perses85428063per__ses
persuades1245623persuades
perturbs1244363perturbs
pertusses1145383pertusses
peruke123210393per_uke_
peruked14367893per_uked
peruse84016843per_use_
perused103112193per_used
peruser93511373per_user
perusers10328803per_users
pervades1437353pervades
plumes104318133p__lumes
precures12312903precures
prefaces15311063prefaces
prefades1439533prefades
prefiles133113443prefiles
prefires134313283prefires
prefixes20389233prefixes
prefunds1454693prefunds
pregames1339003pregames
preludes1137833preludes
prenames12311643prenames
prepubes1436053prepubes
prepuces1438583prepuces
presume11310303presume_
presumed1337973presumed
presumer1247583presumer
presumers1336373presumers
prevues1239263prevu_es
primes104225263p_r_imes
prudes94215443p_r_udes
prunes83419063p_r_unes
purfles122511843purf_les
purpures1276143purpures
pursues94111373pursu_es
reframes1338993reframes
refuges115413373re_fuges
refuses104918553re_fuses
refutes104515733re_futes
relumes9612513re_lumes
reroutes8312223reroutes
resumes9313373re_sumes
serfages1238233serfages
serums83916303ser_um_s
verdures12247753verdures
vermes115019143ver__mes
xeruses143010753xer_uses

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621327.47019566.5
3Display Results1321320.0602200.0
 (SQL Overall)1786911327.93622516.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.