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

204 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
profited1427997(None) 
profiled14338521profiled
profiter132710201profiter
posited10511492p_osited
precited133013812precited
prefiled143310572prefiled
prefired144310752prefired
prefixed21357702prefixed
probated13410862probated
profaned14207972profaned
profile123211152profile_
profiler13287642profiler
profiles133211232profiles
profit113016272profit__
profiteer14274492profiteer
profiters14228312profiters
profits122911242profit_s
promised133010882promised
promoted13310542promoted
prompted1536902prompted
pronated11414052pronated
propined133111512propined
prorated11513712prorated
provided1536842provided
arointed939003arointed
aroynted1244523aroynted
broiled103811423bro_iled
bromated1339173bromated
bromized22215903bromized
bruited104110353br_uited
crafted13419773craf_ted
credited1238253credited
crofter12299573crof_ter
doited85016633_do_ited
drafted12439033draf_ted
drifted12367953drif_ted
erotized1838563erotized
forfeited1643793forfeited
fronted114011273fro_nted
frosted113211883fro_sted
frowsted1534323frowsted
fruited11389093fr_uited
grafted124110223graf_ted
grifted12379583grif_ted
groined92710813gro_ined
grouted94111503gro_uted
ironfisted1442163ironfisted
ironized1858203ironized
lofted103811893_lof_ted
orbited1037733or_bited
parodied1238343parodi_ed
perorated12412473perorated
peroxided2045083peroxided
phonated1447893phonated
phonied133710563phoni_ed
plaited103713893p_laited
plotted104612373plo_tted
podite93315353p_odite_
podites103014733p_odites
pointed103813983p_ointed
poised94918473p_o_ised
policed123212233p_oliced
polite83625073p_olite_
politer92417073p_oliter
ponied94920703p_oni_ed
poofter1237163poof_ter
ported94223243p_o_rted
posted93722493p_o_sted
potted94624013p_o_tted
pouted94021393p_o_uted
praised104214813pr_aised
prated94924923pr__ated
preacted132710943preacted
precised133213413precised
predated12513273predated
predicted1538913predicted
preedited1337633preedited
prefaced1638423prefaced
prefaded1537823prefaded
prefile123413183prefile_
prefiles133113443prefiles
prefilled1535513prefilled
prefire124012813prefire_
prefires134313283prefires
prefixes20389233prefixes
premised133013193premised
premixed20338013premixed
presided12410553presided
presifted1536873presifted
prettied1159253prettied
preunited1246803preunited
prevised143611083prevised
prewired14358473prewired
priced115018883pr__iced
prided103618033pr__ided
pried84426863pr__i_ed
priested1138393priested
primed115118913pr__imed
printed104016373pr_inted
prised94322203pr__ised
prized184415393pr__ized
probate11414483probate_
probates12414283probates
probed114114823pro__bed
probit103218353probit__
probities13312653probities
probits112712573probit_s
probity14299683probit_y
proceed12310553pro_ceed
procured1336603procured
prodded1257733pro_dded
produced1456073produced
proette9312363proette_
proettes10312763proettes
profane122111863profane_
profaner13197943profaner
profanes132311573profanes
professed1545243professed
proffer15126933prof_fer
proffered1843433proffered
profilers14236293profilers
profiteered1751493profiteered
profiteers15213693profiteers
profiting1549983profiting
profitless1542763profitless
profound1444923profound
profuse1237153profuse_
progged12409803pro_gged
prohibited1853473prohibited
projected21165823projected
prolate9419793prolate_
proline92321593proline_
prolines102619693prolines
prologed12189213prologed
promine112819443promine_
promines123018803promines
promise113415843promise_
promisee122711333promisee
promiser122510673promiser
promises122916763promises
promoed12310083pro_moed
promote11313143promote_
promoter12311453promoter
promotes12314123promotes
prompter1437983prompter
pronate9418873pronate_
pronates10418373pronates
pronged113912393pro_nged
proofed13138723pro_ofed
propine113020213propine_
propines122618933propines
proponed132412043proponed
proposed132011083proposed
propped113311963pro_pped
prorate9418733prorate_
prorates10418073prorates
prosected14158633prosected
prosed94921103pro__sed
prosier93817493prosi_er
prosit85124593prosit__
prostie91617743prostie_
prosties101421193prosties
protea82214763pro__tea
protected14158653protected
protei82615313pro__tei
proteid103513673pro__teid
protend104012793pro__tend
protested12159113protested
proved125016033pro__ved
provide1339853provide_
provider1436703provider
provides1439883provides
provoked1875053provoked
prowled13309913pro_wled
proxies163014933proxi_es
purified1438743purifi_ed
pyrolized2446123pyrolized
quoited1756403quo_ited
rafted104714703_raf_ted
recited104319103_recited
refiled114318653_refiled
refined114720003_refined
refired115116993_refired
refitted12309413_refitted
refixed183611153_refixed
refuted114313803_refuted
resited85122423_resited
rifted104115313_rif_ted
roasted83912673_roasted
roiled74320053_ro_iled
roosted83211893_roosted
rooted75424003_ro_oted
rosined84911913_rosined
rotated82715293_rotated
rotted74524433_ro_tted
rousted84013333_rousted
routed75624333_ro_uted
sopited104211063_sopited
sprouted1136393spro_uted
toited74016753_to_ited
trotted83711283tro_tted
uprooted1186393upro_oted
vomited1337253_vomited
worrited1235743worrited

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.450397091.1
2DLD Change Limit1461622047.30020022.2
3Display Results2042040.0932193.5
 (SQL Overall)1786912047.84322783.5
 
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.