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

240 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
profuse123715(None) 
arouse65019982aro_use
crouse84619372cro_use
grouse74315022gro_use
perfuse1247662perfuse
procure1138572procure
produce1267512produce
profane122111862profane
profess1237712profess
profile123211152profile
profs105120892prof_s_
profusely1743062profusely
profusive1743762profusive
promise113415842promise
propose112714842propose
prose75835122pro__se
refuse94817512_refuse
rouse56634702_ro_use
uprouse937222upro_use
arose55832083aro__se
aroused84914353aro_used
arouser74514423aro_user
arouses74921293aro_uses
blouse84714723blo_use
bouse75931853_bo_use
brogue94211033brogu_e
brogues10719823brogues
brose75227033bro__se
browse115713863bro_wse
carouse9614423caro_use
chouse116017563cho_use
confuse1238853confuse
crocus104813173crocus_
crocuses1239023crocuses
crofts114910593crofts_
crosse85216313cro_sse
croupe105114433cro_upe
croute84617273cro_ute
cruse75726103cr__use
defuse105712723_defuse
diffuse1444383diffuse
doofus1036163doofus_
doofuses1244283doofuses
douse66329723_do_use
drogue8938333drogu_e
drogues9398393drogues
drowse105010553dro_wse
druse64817663dr__use
effuse1234963_effuse
erose55727283ero__se
fuse76429993___fuse
groused94712843gro_used
grouser84513693gro_user
grouses84616543gro_uses
house89131423_ho_use
infuse93110573_infuse
louse56131013_lo_use
mouse77133003_mo_use
nonuse63212253_nonuse
parous84024163paro_us_
pause75021833p__ause
perfume1446503perfume
perfused1445843perfused
perfuses1358663perfuses
peruse84016843p_eruse
pious74621273pio_us_
pirogue1045413pirogu_e
pirogues1135473pirogues
piroque1844353piroqu_e
piroques1944353piroques
poise75127893p_o_ise
poofs105222793poof_s_
porose84818743p_orose
porous84419483porous_
pose66441733p_o__se
posse74722273p_o_sse
pouffe14448263p_ouffe
poufs105616063p_oufs_
prahus11458243prahus_
praise84419413pr_aise
prase76128753pr__ase
praus74621753pr_aus_
precise113518173precise
precure11312553precure
predusk1443773predusk
preface14510923preface
prefade1339013prefade
prefile123413183prefile
prefire124012813prefire
prefund1335733prefund
prelude1038013prelude
premise113818553premise
premune1138933premune
prepuce1337833prepuce
prese75228383pr__ese
presume11310303presume
previse123713793previse
prevue1179163prevu_e
prevues1239263prevues
primus103712173primus_
primuses1237083primuses
prise74632613pr__ise
proas75028803pro_as_
probate11414483probate
probe94320813pro__be
probes104119453probes_
process11310403process
procured1336603procured
procurer1235833procurer
procures1239213procures
prods85523553pro_ds_
produced1456073produced
producer1355843producer
produces1347903produces
product1279233product
proems104711163proems_
proette9312363proette
prof96134663prof___
profaned14207973profaned
profaner13197943profaner
profanes132311573profanes
professed1545243professed
professes1437873professes
proffer15126933proffer
profiled14338523profiled
profiler13287643profiler
profiles133211233profiles
profit113016273prof_it
profited14279973profited
profiter132710203profiter
profits122911243profits
profound1444923profound
profusion1445703profusion
prognose1146463prognose
progs86624153pro_gs_
progun968783progu_n
prolapse12134913prolapse
prolate9419793prolate
prole74527793pro__le
proles84627203proles_
proline92321593proline
promine112819443promine
promised133010883promised
promisee122711333promisee
promiser122510673promiser
promises122916763promises
promos105116423promos_
promote11313143promote
proms95426413pro_ms_
promulge1343043promulge
pronate9418873pronate
prone75332623pro__ne
prongs94314483prongs_
proofs114511683proofs_
propane112716153propane
propene112716043propene
propense122410103propense
prophase15410243prophase
propine113020213propine
propone112716303propone
proposed132011083proposed
proposer121810633proposer
proposes122515973proposes
props95726883pro_ps_
prorate9418733prorate
pros65742783pro__s_
prosed94921103pro__sed
proser84223463pro__ser
proses84733473pro__ses
proso77222413pro__so
prosos85718553prosos_
pross76529403pro__ss
prosses94019513pro_sses
prossie91812963prossie
prost75434103pro__st
prostie91617743prostie
prosy106319253pro__sy
protases102115033protases
protease10209893protease
protege1059153protege
proteose10229413proteose
protest9317533protest
proteus92511593proteus_
proteuses11238993proteuses
protist9320223protist
protrude1144703protrude
protyle12229453protyle
proud84615483pro_u_d
prouder10310383pro_uder
prove104823193pro__ve
proves114322253proves_
provide1339853provide
proviso1237313proviso
provoke1676123provoke
provost1238573provost
prowess1237903prowess
prowest12311533prowest
prowls115511083prowls_
prows106327013pro_ws_
proxies163014933proxies
prude84615973pr__ude
prune75119633pr__une
prunus8399363prunus_
prunuses1035123prunuses
recuse85519163_recuse
refuge105312613_refuge
refused115114443_refused
refuser104912783_refuser
refuses104918553_refuses
refute95515703_refute
retuse66617223_retuse
reuse56025363_r_euse
robust8310433_robust
rogue66417533_rogu_e
rogues74617673_rogues
roose56127093_ro_ose
roque144812133_roqu_e
roques154912563_roques
rose46148903_ro__se
roue45941743_ro_u_e
roues56039353_ro_ues
rouge65423443_ro_uge
roused75426453_ro_used
rouser65224083_ro_user
rouses65436283_ro_uses
roust55532063_ro_ust
route55132073_ro_ute
ruse45938933_r__use
scouse84113633sco_use
souse56530773_so_use
spouse84112513spo_use
suffuse1335443suffuse
tofus86415423_tofus_
touse55430673_to_use
troupe84812433tro_upe
trouser73812473tro_user
uprose82311483upro__se
uproused1135843upro_used
uprouses1037553upro_uses
youse85322233_yo_use

Search took 10 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 Limit1340272408.62615537.6
3Display Results2402400.0763157.9
 (SQL Overall)1786912409.10819619.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.