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

233 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
profiles13321123(None) 
prefiles133113441prefiles
profile123211151profile_
profiled14338521profiled
profiler13287641profiler
profilers14236291profilers
prefile123413182prefile_
prefiled143310572prefiled
prefires134313282prefires
prefixes20389232prefixes
profanes132311572profanes
profited14279972profited
profiter132710202profiter
profiters14228312profiters
profitless1542762profitless
profits122911242profi_ts
proles84627202pro__les
prolines102619692prolines
promines123018802promines
promises122916762promises
propines122618932propines
protyles13249832protyles
provides1439882provides
proxies163014932proxi_es
refiles104122422_refiles
biofilms1542773biofilms
broiled103811423bro_iled
broiler92911753bro_iler
broilers103210093bro_ilers
broils84114173bro_il_s
brollies1039533brollies
bromides13219373bromides
bromines122514253bromines
bromizes21258333bromizes
coffles152610003_coffles
cronies9622513croni_es
defiles114016843_defiles
erotizes17311213erotizes
etoiles7411293eto_iles
files85441273___files
graciles112511613graciles
ironies7517423ironi_es
ironizes17510373ironizes
misfiles133110983misfiles
mobiles112813123_mobiles
motiles93317433_motiles
orifices1346483orifices
oroides8311973oro_ides
pantiles103617153pantiles
parodies11313693parodi_es
paroles95025883paro__les
peonies93620153peoni_es
peoples11312223peo_ples
peroxides1947493peroxides
phonies123717513phoni_es
piffles15368763p_iffles
piles74742613p___iles
pirogies1139423pirogi_es
pliofilms1651433pliofilms
plosives1335893plosives
podites103014733p_odites
pogies94123543p_ogi_es
poilus82210573p_o_ilus
poises84226543p_o_ises
pokies125921333p_oki_es
poles75351003p_o__les
polices113118053p_olices
polies84034583p_oli_es
ponies84833463p_oni_es
poodles103013513p_oodles
popples103011873p_opples
porgies103017003porgi_es
porkies133416493porki_es
posies84431433p_osi_es
posoles9314883p_osoles
pottles93816983p_ottles
pozoles1839063p_ozoles
praises94121103pr_aises
pralines102217723pralines
prattles10189403prattles
praxises1739063praxises
prebills1237293prebills
precipes143212213precipes
precises123218333precises
prefaces15311063prefaces
prefades1439533prefades
prefilled1535513prefilled
prefire124012813prefire_
prefired144310753prefired
prefixed21357703prefixed
prelives13310383prelives
premies113823063premi_es
premises123018273premises
premixes193110083premixes
presales10315263presales
presides11414913presides
previses133814283previses
prewires133811013prewires
prexies163415003prexi_es
prices104524543pr__ices
prickles162511093prickles
prides94324183pr__ides
pries74339533pr__i_es
prills84015613pr__ills
primes104225263pr__imes
primines123013703primines
priories10312453priori_es
prises84133173pr__ises
privies122414263privi_es
prizes173819813pr__izes
probables1545433probables
probates12414283probates
probes104119453pro__bes
probities13312653probities
probits112712573probi_ts
problem1335983pro_blem
problems1434343pro_blems
procaines13311523procaines
proclises1339543proclises
procures1239213procures
prodigies1346953prodigies
produces1347903produces
proettes10312763proettes
profane122111863profane_
profaned14207973profaned
profaner13197943profaner
profaners14256213profaners
profess1237713prof_ess
professes1437873professes
proffer15126933prof_fer
proffers16126593proffers
profiling1548233profiling
profilings1653563profilings
profit113016273profi__t
profiteer14274493profiteer
profiteers15213693profiteers
profs105120893prof___s
profuse1237153profuse_
prole74527793pro__le_
proleg94612113pro__leg
prolegs10379993pro__legs
proline92321593proline_
promine112819443promine_
promise113415843promise_
promised133010883promised
promisee122711333promisee
promisees13246863promisees
promiser122510673promiser
promisers13268203promisers
promotes12314123promotes
promulges1443383promulges
pronates10418373pronates
propanes122415823propanes
propels113412843propel_s
propenes122816513propenes
propine113020213propine_
propined133111513propined
propolis12311403propolis
propones122516963propones
proposes122515973proposes
propyls14308193propyl_s
prorates10418073prorates
proses84733473pro__ses
prosier93817493prosi_er
prosiest10416523prosi_est
prosily12611633prosil_y
prosiness11311693prosiness
prosses94019513pro_sses
prossies101515233prossies
prosties101421193prosties
prostyles14157113prostyles
protases102115033protases
proteges1149923proteges
proteides12238793proteides
protists10313363protists
protiums1238563protiums
protyle12229453protyle_
protyls12298463protyl_s
proves114322253pro__ves
provide1339853provide_
provided1536843provided
provider1436703provider
providers1535593providers
provinces1646853provinces
provirus1345453provirus
provisoes1446653provisoes
provisos1336913provisos
provokes1776603provokes
prowled13309913pro_wled
prowler123310013pro_wler
prowlers13328933pro_wlers
prowls115511083pro_wl_s
purfles122511843purf_les
purifies13311923purifi_es
pyrolizes2347233pyrolizes
pyronines1458323pyronines
pyrosises1457583pyrosises
raffles133611843_raffles
refile95122373_refile_
refiled114318653_refiled
refills103711423_refills
refilms12347503_refilms
refines105426343_refines
refires104820313_refires
refixes174813173_refixes
reflies104418533_reflies
resiles74026543_resiles
retiles74426993_retiles
reviles104421353_reviles
riffles133911163_riffles
rifles94217703_rif_les
riles55343643_r__iles
robles85321693_ro_bles
roiled74320053_ro_iled
roils54826793_ro_il_s
roles56747983_ro__les
roofies103014413roofi_es
rootles73215633_rootles
roubles93413513_roubles
rouilles837183_rouilles
ruffles133512273_ruffles
rutiles74315843_rutiles
strobiles1146953strobiles
subfiles131710723subfiles
toiles63923513_to_iles
trifles103814823trif_les
troilus736413tro_ilus
trollies8310233trollies
tropines102214923tropines
troubles1057203troubles
truffles1485593truffles
urodeles945563urodeles
voiles94616443_vo_iles

Search took 9 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.420425454.8
2DLD Change Limit1461622337.79618748.3
3Display Results2332330.0962427.1
 (SQL Overall)1786912338.31221498.0
 
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.