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

217 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
profane12211186(None) 
profaned14207971profaned
profaner13197941profaner
profanes132311571profanes
propane112716151propane
preface14510922preface
prefade1339012prefade
proband122710242proband
probang12278382probang
probate11414482probate
procaine12312272procaine
profanely1743752profanely
profaners14256212profaners
profile123211152profile
profuse1237152profuse
prolan8414692prolan_
prolans9314272prolans
prolate9419792prolate
proline92321592proline
promine112819442promine
pronate9418872pronate
prone75332622pro__ne
propanes122415822propanes
propene112716042propene
propine113020212propine
propone112716302propone
prorate9418732prorate
arcane81216743ar_cane
borane84620213_borane
brocade1238533brocade
brogan9311043brogan_
brogans1049663brogans
brokage1436673brokage
bromate11313553bromate
bromine112915243bromine
crane75331603cr__ane
crocine11314153crocine
crone75231333cro__ne
dioxane1565423dioxane
drone65324983dro__ne
fane75343573___fane
fromage1336753fromage
groan65618423gro_an_
groaned9259973gro_aned
groaner82510133gro_aner
groans74815063gro_ans
groyne1037213gro_yne
irone55126363iro__ne
krone94018733kro__ne
pane64950293p___ane
paravane1348103paravane
pavane114113443p_avane
pentane9415743pentane
peonage1048723peonage
perorate10417923perorate
phocine1438833phocine
phonate12411813phonate
phone105621933pho__ne
phorate12413363phorate
phytane1545443phytane
plane74929143p__lane
platane93112303platane
pomace123111913p_omace
pomade113611333p_omade
pone65747533p_o__ne
porcine11312843porcine
portage103013643portage
portance12310123portance
potage92715903p_otage
praline93019743praline
prance104318573pr__ance
prang84820323pr__ang
prank115019453pr__ank
prase76128753pr__ase
prate75135983pr__ate
prebade12310283prebade
prebake1539093prebake
predate10616893predate
prefab1336243prefa_b
prefabs1435163prefabs
prefaced1638423prefaced
prefacer1537983prefacer
prefaces15311063prefaces
prefaded1537823prefaded
prefades1439533prefades
prefile123413183prefile
prefire124012813prefire
preflame1545913preflame
prefrank1764233prefrank
prefund1335733prefund
pregame1239553pregame
prelate9519693prelate
premade12311443premade
preman104117453preman_
premune1138933premune
prename11412643prename
prepare111913623prepare
prepave14228873prepave
prerace11414123prerace
presage10312293presage
presale9416353presale
pretape113511623pretape
primage12169143primage
primate111516283primate
primine113214823primine
priorate10411733priorate
pristane10310343pristane
private121513263private
proa66229963pro_a__
proas75028803pro_a_s
probable1439053probable
probands13228393probands
probangs13256213probangs
probated13410863probated
probates12414283probates
probe94320813pro__be
probing123314443probing
procaines13311523procaines
procarp1346823procarp
procure1138573procure
produce1267513produce
proette9312363proette
prof96134663prof___
profaning1537293profaning
profanity1744793profanity
profess1237713profess
proffer15126933proffer
profiled14338523profiled
profiler13287643profiler
profiles133211233profiles
profit113016273prof_it
profited14279973profited
profiter132710203profiter
profits122911243profits
profound1444923profound
profs105120893prof__s
progeny1389463progeny
prograde1247183prograde
progun968783progun_
prolamine131510563prolamine
prolapse12134913prolapse
prole74527793pro__le
prolines102619693prolines
prolong10319633prolong
prolonge11388403prolonge
promines123018803promines
promise113415843promise
promote11313143promote
pronated11414053pronated
pronates10418373pronates
prong85218113pro__ng
proofing1439313proofing
propend123311273propend
propenes122816513propenes
propense122410103propense
prophage1649433prophage
prophase15410243prophase
propined133111503propined
propines122618933propines
propman1339063propman_
propmen1338763propmen
proponed132412033proponed
propones122516963propones
propose112714843propose
prorated11513713prorated
prorates10418073prorates
prosaic11311163prosaic
prose75835123pro__se
prosing103319383prosing
prossie91812953prossie
prostate10314533prostate
prostie91617743prostie
protamine131310913protamine
protases102115033protases
protean92412193protean_
proteans102811543proteans
protease10209893protease
protege1059153protege
protend104012793protend
proton84318893proton_
protons93118003protons
protrade1148213protrade
protyle12229453protyle
provable1539093provable
prove104823193pro__ve
proven114314773proven_
provide1339853provide
province1546923province
proving134214073proving
provoke1676123provoke
prowar114110943prowa_r
prune75119633pr__une
psoae74411623pso_a_e
ptomaine1245533ptomaine
purslane1045783purslane
pyrone112714473pyro__ne
pyronine1349513pyronine
pyroxene2045083pyroxene
recane83022873_recane
reface113616353_reface
refine95225693_refine
roan47234203_ro_an_
roans54926443_ro_ans
roband92310723_roband
romaine9512123_romaine
roman75424823_roman_
romance11311083_romance
romano84912943_romano
romans84620243_romans
rotate63320343_rotate
rowan85418733_rowan_
rowans95715343_rowans
tolane64316583_tolane
troland837543troland
trone55131863tro__ne
tropine93116653tropine
urbane82211383ur_bane

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 Limit1340272177.06318975.9
3Display Results2172170.0762855.3
 (SQL Overall)1786912177.54523683.4
 
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.