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

185 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
profiled1433852(None) 
prefiled143310571prefiled
profile123211151profile_
profiler13287641profiler
profiles133211231profiles
profited14279971profited
broiled103811422bro_iled
prefile123413182prefile_
prefiles133113442prefiles
prefilled1535512prefilled
prefired144310752prefired
prefixed21357702prefixed
profaned14207972profaned
profilers14236292profilers
profiter132710202profiter
promised133010872promised
propined133111502propined
provided1536842provided
prowled13309912pro_wled
refiled114318652_refiled
roiled74320052_ro_iled
ariled75620323ar__iled
boiled95020953_bo_iled
brailed103914013br_ailed
broiler92911753bro_iler
bromized22215903bromized
coffled16297363_coffled
coiled95123943_co_iled
defiled124013103_defiled
doiled84817293_do_iled
drolled93810223dro_lled
drooled9369203dro_oled
erotized1838553erotized
filed95331903___filed
foiled104618403_fo_iled
groined92710813gro_ined
groveled13345453groveled
growled12278173gro_wled
ironized1858203ironized
misfiled14278653misfiled
moiled94318863_mo_iled
oiled64429473__o_iled
pantiled113111593pantiled
parboiled1445223parboiled
parodied1238333parodi_ed
paroled104217633paro__led
penciled1337823penciled
peopled1238503peo_pled
periled10316323p_eriled
peroxided2045073peroxided
phonied133710563phoni_ed
piffled16366403p_iffled
piled85232993p___iled
poised94918473p_o_ised
poled84934843p_o__led
policed123212233p_oliced
polled94022003p_o_lled
ponied94920703p_oni_ed
pooled94619813p_o_oled
poppled11339243p_oppled
portaled11239203portaled
posited10511493p_osited
praised104214813pr_aised
prattled11246533prattled
prebilled1445063prebilled
preboiled1455783preboiled
precised133213413precised
precited133013813precited
prefaced1638423prefaced
prefaded1537823prefaded
prefire124012813prefire_
prefires134313283prefires
prefixes20389233prefixes
premised133013193premised
premixed20338013premixed
presided12410553presided
prevailed1536043prevailed
prevised143611073prevised
prewired14358473prewired
priced115018883pr__iced
prickled17358073prickled
prided103618033pr__ided
pried84426863pr__i_ed
prilled104713003pr_illed
primed115118913pr__imed
prised94322203pr__ised
prized184415393pr__ized
probated13410863probated
probed114114823pro__bed
problem1335983pro_blem
proceed12310553pro_ceed
procured1336603procured
prodded1257733pro_dded
produced1456073produced
profane122111863profane_
profaner13197943profaner
profanes132311573profanes
professed1545243professed
proffer15126933prof_fer
proffered1843433proffered
profiling1548233profiling
profit113016273profi__t
profiteer14274493profiteer
profiters14228313profiters
profitless1542763profitless
profits122911243profi_ts
profound1444923profound
profuse1237153profuse_
progged12409803pro_gged
prole74527793pro__le_
proleg94612113pro__leg
proles84627203pro__les
proline92321593proline_
prolines102619693prolines
prologed12189213prologed
promine112819443promine_
promines123018803promines
promise113415843promise_
promisee122711333promisee
promiser122510673promiser
promises122916763promises
promoed12310083pro_moed
promoted13310543promoted
prompted1536903prompted
promulged1542433promulged
pronated11414053pronated
pronged113912393pro_nged
proofed13138723pro_ofed
propelled1456913propelled
propine113020213propine_
propines122618933propines
proponed132412033proponed
proposed132011073proposed
propped113311953pro_pped
prorated11513713prorated
prosed94921093pro__sed
prosier93817483prosi_er
prosily12611633prosil_y
protyle12229453protyle_
protyles13249833protyles
proved125016033pro__ved
provide1339853provide_
provider1436703provider
provides1439883provides
provoked1875053provoked
prowler123310013pro_wler
proxies163014933proxi_es
purfled13248733purf_led
purified1438743purifi_ed
pyrolized2446123pyrolized
raffled14429083_raffled
railed74727543_r_ailed
refile95122373_refile_
refiles104122423_refiles
refilled12278673_refilled
refilmed14235813_refilmed
refined114720003_refined
refired115116993_refired
refixed183611153_refixed
reoiled84316853_reoiled
resiled84621983_resiled
retiled84420513_retiled
reviled114417923_reviled
riffled14338603_riffled
rifled104115003_rif_led
riled65833253_r__iled
rolled74220243_ro_lled
rootled83410533_rootled
rosined84911903_rosined
roweled11269863_roweled
ruffled14369153_ruffled
soiled73822473_so_iled
spoiled104811353spo_iled
toiled74420323_to_iled
trailed83415673tr_ailed
trifled113711963trif_led
trolled84312263tro_lled
trollied935893trollied
troubled1134983troubled
troweled12106113troweled
truffled1563993truffled
unfoiled12249723unfoiled
unoiled82415483uno_iled
upboiled13194853upbo_iled
upcoiled13215183upco_iled

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.423422437.4
2DLD Change Limit1461621856.53022383.2
3Display Results1851850.0802312.5
 (SQL Overall)1786911857.03325407.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.