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

152 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
profaned1420797(None) 
profane122111861profane_
profaner13197941profaner
profanes132311571profanes
groaned9259972gro_aned
prefaced1638422prefaced
prefaded1537822prefaded
proband122710242proban_d
probated13410862probated
profanely1743752profanely
profaners14256212profaners
profiled14338522profiled
profited14279972profited
pronated11414052pronated
propane112716152propane_
propanes122415822propanes
propined133111502propined
proponed132412032proponed
prorated11513712prorated
aproned10311503apro__ned
brocaded1436353brocaded
bromated1339173bromated
browned134710973bro_wned
craned96121653cr__aned
croaked143710533cro_aked
crooned103813343cro_oned
crowned133912433cro_wned
droned84616863dro__ned
drowned12419903dro_wned
frowned14348833fro_wned
gowaned1235763_gowaned
groaner82510133gro_aner
groined92710813gro_ined
ironed74916013iro__ned
loaned73816293_lo_aned
moaned94514173_mo_aned
orphaned1445153orphaned
paned85437183p___aned
perorated12412463perorated
phonated1447893phonated
phoned124014553pho__ned
planed94420913p__laned
pomaded13377863p_omaded
portaged12228463portaged
portaled11239203portaled
pranced123714043pr__anced
pranged114512553pr__anged
pranked143712093pr__anked
prated94924923pr__ated
prawned1346743pr_awned
prayed124815433pr__ayed
preaged11612333pr_eaged
prebaked1737173prebaked
predated12513273predated
preened103214993pr_eened
prefabbed1942323prefabbed
preface14510923preface_
prefacer1537983prefacer
prefaces15311063prefaces
prefade1339013prefade_
prefades1439533prefades
prefiled143310573prefiled
prefired144310753prefired
prefixed21357703prefixed
prefranked2042773prefranked
prefund1335733prefun_d
prefunded1644693prefunded
preowned1435213preowned
prepared132210873prepared
prepaved16177233prepaved
presaged1238803presaged
pretaped13339133pretaped
prewarned1594773prewarned
prisoned1138813prisoned
probands13228393probands
probang12278383proban_g
probangs13256213probangs
probate11414483probate_
probates12414283probates
probed114114823pro__bed
procaine12312273procaine_
procaines13311523procaines
proceed12310553pro_ceed
procured1336603procured
prodded1257733pro_dded
produced1456073produced
profaning1537293profaning
profanity1744793profanity
professed1545243professed
proffer15126933prof_fer
proffered1843433proffered
profile123211153profile_
profiler13287643profiler
profiles133211233profiles
profiter132710203profiter
profound1444923profound
profuse1237153profuse_
progged12409803pro_gged
programed1585893programed
prolan8414693prolan__
prolans9314273prolan_s
prolapsed14133733prolapsed
prolate9419793prolate_
proline92321593proline_
prolines102619693prolines
prologed12189213prologed
prolonged13285413prolonged
promine112819443promine_
promines123018803promines
promised133010873promised
promoed12310083pro_moed
promoted13310543promoted
prompted1536903prompted
pronate9418873pronate_
pronates10418373pronates
prone75332623pro__ne_
pronged113912393pro_nged
proofed13138723pro_ofed
propend123311273propen_d
propended1546163propended
propene112716043propene_
propenes122816513propenes
propine113020213propine_
propines122618933propines
propone112716303propone_
propones122516963propones
proposed132011073proposed
propped113311953pro_pped
prorate9418733prorate_
prorates10418073prorates
prosed94921093pro__sed
protases102115033protases
protend104012793proten_d
protended1336803protended
proved125016033pro__ved
provided1536843provided
provoked1875053provoked
prowled13309913pro_wled
pruned93413113pr__uned
recaned102817203_recaned
refaced133713573_refaced
refined114720003_refined
roamed95215093_ro_amed
roared75015393_ro_ared
roband92310723_roban_d
romanced1337253_romanced
rosined84911903_rosined
rotated82715293_rotated
sofabed1334333_sofabed
troaked12438253tro_aked
troland837543trolan_d
womaned1337213_womaned

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.440406115.9
2DLD Change Limit1461621527.14020470.9
3Display Results1521520.0632412.7
 (SQL Overall)1786911527.64323379.7
 
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.