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

237 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
profile12321115(None) 
prefile123413181prefile
profiled14338521profiled
profiler13287641profiler
profiles133211231profiles
prefiled143310572prefiled
prefiles133113442prefiles
prefire124012812prefire
profane122111862profane
profilers14236292profilers
profit113016272profi_t
profited14279972profited
profiter132710202profiter
profits122911242profits
profuse1237152profuse
prole74527792pro__le
proline92321592proline
promine112819442promine
promise113415842promise
propine113020212propine
prosily12611632prosily
protyle12229452protyle
provide1339852provide
refile95122372_refile
biofilm1444333biofilm
broil74918223bro_il_
broiled103811423bro_iled
broiler92911753bro_iler
broils84114173bro_ils
bromide12269583bromide
bromine112915243bromine
bromize20238823bromize
coffle14359043_coffle
crocine11314153crocine
defile105216663_defile
docile94213123_docile
erodible1145493erodible
erosible1046443erosible
erosive1039193erosive
erotize16311663erotize
etoile6312263eto_ile
file75446643___file
fragile1147843fragile
goofily14105353goofily
gracile102512603gracile
ironize16610373ironize
misfile122611553misfile
mobile103613543_mobile
motile83818343_motile
orifice1246343orifice
oroide7311703oro_ide
pantile93918483pantile
parole84425253paro__le
penile82219603p_enile
pensile92713543pensile
people10310193peo_ple
peroxide1848183peroxide
phocine1438833phocine
phonily1537103phonily
piffle14418233p_iffle
pile65649693p___ile
pliofilm1542083pliofilm
plosive1236673plosive
podite93315353p_odite
poilu72316003p_o_ilu
poise75127893p_o_ise
pokily15309063p_okily
pole65951303p_o__le
police102918563p_olice
polite83625073p_olite
poodle93112043p_oodle
popple92710983p_opple
porcine11312843porcine
posole8314223p_osole
pottle84416103p_ottle
pozole1758913p_ozole
praise84419413pr_aise
praline93019743praline
prattle9208833prattle
prebill1138803prebill
precipe133012123precipe
precise113518173precise
predive13511083predive
preface14510923preface
prefade1339013prefade
prefilled1535513prefilled
prefired144310753prefired
prefires134313283prefires
prefix18356853prefi_x
prefixed21357703prefixed
prefixes20389233prefixes
prelife1279943prelife
premie103617993premi_e
premise113818553premise
prepill1147583prepill
presale9416353presale
preside10715613preside
previse123713793previse
prewire124311143prewire
price93725413pr__ice
pricily142710283pricily
prickle153611013prickle
pride84724733pr__ide
prill74117943pr__ill
prime96525603pr__ime
primine113214823primine
prise74632613pr__ise
privily15207623privily
prize164718943pr__ize
probable1439053probable
probate11414483probate
probe94320813pro__be
probing123314443probing
probit103218353probi_t
probits112712573probits
probity14299683probity
problem1335983pro_blem
procaine12312273procaine
procure1138573procure
prodigy1435573prodigy
produce1267513produce
proette9312363proette
prof96134663prof___
profamily1943633profamily
profaned14207973profaned
profaner13197943profaner
profanes132311573profanes
profess1237713profess
proffer15126933proffer
profiling1548233profiling
profitable1744963profitable
profiteer14274493profiteer
profiters14228313profiters
profitless1542763profitless
profs105120893prof__s
profusive1743753profusive
prolate9419793prolate
proleg94612113pro__leg
proles84627203pro__les
prolines102619693prolines
prolix1538683proli_x
prolixly2043113prolixly
promines123018803promines
promised133010873promised
promisee122711333promisee
promiser122510673promiser
promises122916763promises
promote11313143promote
promulge1343043promulge
pronate9418873pronate
prone75332623pro__ne
pronely12310253pronely
proofing1439313proofing
propane112716153propane
propel103714063propel_
propels113412843propels
propene112716043propene
propined133111503propined
propines122618933propines
propone112716303propone
propose112714843propose
propyl13358183propyl_
propyla14296633propyla
propyls14308193propyls
prorate9418733prorate
prose75835123pro__se
prosier93817483prosier
prosing103319383prosing
prosit85124593prosi_t
prossie91812953prossie
prostie91617743prostie
prostyle13187273prostyle
protege1059153protege
proteide11239723proteide
protist9320223protist
protium11312293protium
protyl11308213protyl_
protyles13249833protyles
protyls12298463protyls
proudly1336333proudly
provable1539093provable
prove104823193pro__ve
provided1536843provided
provider1436703provider
provides1439883provides
province1546923province
proving134214073proving
proviso1237313proviso
provoke1676123provoke
prowl105615123pro_wl_
prowled13309913pro_wled
prowler123310013pro_wler
prowls115511083pro_wls
proxies163014933proxies
proximo1845143proximo
puerile9310093puerile
puffily1834843puffily
purfle112511183purf_le
pyrolize2248133pyrolize
pyronine1349513pyronine
raffle123910703_raffle
refiled114318653_refiled
refiles104122423_refiles
refill94514053_refill
refilm114311403_refilm
refine95225693_refine
refire95419473_refire
resile64627673_resile
retile65929673_retile
revile94921613_revile
riffle124210233_riffle
rifle85518333_rif_le
rile45650533_r__ile
roble75223023_ro_ble
roil46235293_ro_il_
roiled74320053_ro_iled
roils54826793_ro_ils
roily86121113_ro_ily
role45851823_ro__le
roofie93411173roofi_e
rootle63214453_rootle
ropily113312443_ropily
rosily93914713_rosily
rouble83913313_rouble
rouille737493_rouille
ruffle124111673_ruffle
rutile65217683_rutile
strobile1047033strobile
subfile122010503subfile
toile54626493_to_ile
tortile7313193tortile
trifle94012883trif_le
tropine93116653tropine
trouble957713trouble
truffle1384893truffle
urodele845963urodele
voile84719723_vo_ile

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 Limit1340272377.17318684.9
3Display Results2372370.0932548.4
 (SQL Overall)1786912377.67223291.3
 
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.