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 “profaners” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
profaners1425621(None) 
profaner13197941profaner_
profanes132311571profane_s
groaners9248502gro_aners
prefacers1636292prefacers
profane122111862profane__
profaned14207972profane_d
profanely1743752profanely
proffers16126592prof_fers
profilers14236292profilers
profiters14228312profiters
propanes122415822propane_s
croakers14288523cro_akers
crofters13358903crof_ters
crooners103911393cro_oners
crowners133710753cro_wners
droners84114383dro__ners
drowners12428273dro_wners
frowners14377933fro_wners
groaner82510133gro_aner_
ironers74813553iro__ners
loaners73913623_lo_aners
moaners92813553_mo_aners
planers94517943p__laners
pomanders1436223p_omanders
poofters1336923poof_ters
prancers123210333pr__ancers
praters94921653pr__aters
prawners1346003pr_awners
prayers124212853pr__ayers
preavers13910263pr_eavers
precancers1645253precancers
preeners102712813pr_eeners
prefacer1537983prefacer_
prefaces15311063preface_s
prefades1439533prefade_s
prefers123713333pref__ers
preparers13197673preparers
presagers1236943presagers
prisoners1147373prisoners
probands13228393proban_ds
probangs13256213proban_gs
probates12414283probate_s
probers113514583pro__bers
procaines13311523procaine_s
procurers1345033procurers
prodders1237463pro_dders
producers1454883producers
profaneness1653583profaneness
profaning1537293profaning
profanity1744793profanity
profess1237713prof__ess
proffer15126933prof_fer_
profferers1842423profferers
profiler13287643profiler_
profiles133211233profile_s
profiteers15213693profiteers
profiter132710203profiter_
proggers12258163pro_ggers
programers1584403programers
prolans9314273prolan__s
prolines102619693proline_s
prolongers13264763prolongers
promines123018803promine_s
promisers13268203promisers
promoters13310093promoters
prompters1537553prompters
pronates10418373pronate_s
pronators11411303pronators
proneness11310443proneness
proofers13118363pro_ofers
propane112716153propane__
propenes122816513propene_s
propers113619033pro__pers
propines122618933propine_s
propones122516963propone_s
proposers13228523proposers
prorates10418073prorate_s
prosateurs1243063prosateurs
prosers94219643pro__sers
prosiness11311683prosiness
prospers123012263pro_spers
protases102115033protase_s
proudness1246693proudness
provenders1644273provenders
provers123817793pro__vers
providers1535593providers
provokers1894203provokers
prowlers13328933pro_wlers
pruners93710723pr__uners
refiners114713313_refiners
roamers93713463_ro_amers
roarers73812743_ro_arers
romancers1345733_romancers
troffers14125433trof_fers

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 Filter1786911486410.436409841.7
2DLD Change Limit148641957.70319296.5
3Display Results95950.0462065.2
 (SQL Overall)178691958.18521831.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.