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

217 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
prorating1231428(None) 
perorating13313131perorating
probating14311181probating
pronating12313761pronating
borating113414502_borating
bromating1439162bromating
orating83520322__orating
perforating1747022perforating
phonating1537812phonating
pirating11314512p_irating
porting103021782p_or_ting
prating103424452p__rating
predating13514652predating
procreating1647692procreating
profaning1537292profaning
profiting1549982profiting
programing1646302programing
promoting1439912promoting
prompting1637192prompting
proration11415982proration
prorations12314462prorations
prorogating1556052prorogating
prostrating1449392prostrating
protracting1646932protracting
rotating92614552_rotating
aborting11710253abor_ting
abrogating1497983abrogating
aerating92821003_aerating
approbating1844583approbating
arointing1049363arointing
aroynting1344633aroynting
arraying1238753ar_raying
arrogating121778393arrogating
berating113220763_berating
bloating113512813blo_ating
boating103721303_bo_ating
brocading1556253brocading
coating103525313_co_ating
coronating13410173coronating
corotating1349323corotating
corrading1338203corrading
crating103725203__crating
creating113921953cr_eating
cremating14312193cremating
croaking153712163cro_aking
curating11314293_curating
decorating14312073decorating
derating103222283_derating
derogating1348633derogating
disrating11714553disrating
doating93816863_do_ating
donating10311803_donating
floating123111883flo_ating
foraging1358063_foraging
foraying1537433_foraying
fronting12310443fro_nting
frosting12311183fro_sting
frowsting1634683frowsting
gloating102611463glo_ating
gradating1237313gradating
grating93923183__grating
groaning102410283gro_aning
grouting103410793gro_uting
gyrating1337453_gyrating
hoorahing1644913hoorahing
hooraying1644783hooraying
hydrating1746323hydrating
iodating1038823_iodating
isolating1039743isolating
iterating10314253iterating
librating1239053librating
locating11311503_locating
migrating13910533migrating
misrating121014853misrating
moating104218153_mo_ating
narrating10310353narrating
nitrating10312673nitrating
notating92513343_notating
operating12313723operating
outrating10916403outrating
ozonating1944323ozonating
palpating1438533palpating
parading12313863p_arading
parawing14310583p_arawing
parroting1239153parroting
parting103527383p_ar_ting
patriating13510203patriating
percolating1657313percolating
permeating1539923permeating
peroration12316003peroration
perorations13314063perorations
personating1447673personating
phrasing1438013p_hrasing
placating1438513placating
plating103823073p__lating
pleating112916053p_leating
plotting113011013plo_tting
pointing112813683p_ointing
pomading1437423p_omading
poring94227273p_or__ing
porking143515813p_or_king
portaging1346843portaging
portraying1645163portraying
positing11312303p_ositing
posting105622243p_o_sting
potting103720893p_o_tting
pouting103519943p_o_uting
praying133717323p__raying
preacting142412533preacting
prearming14139223prearming
prebaking1838063prebaking
precasting15169833precasting
prefacing17118743prefacing
prefading16149033prefading
preheating16310723preheating
prelocating1647413prelocating
preparing14311643preparing
prepasting15168873prepasting
prepaving1787233prepaving
prepaying1747973prepaying
presaging1339393presaging
presorting1339983presor_ting
pretaping1439133pretaping
pretasting13239283pretasting
pretreating1448893pretreating
prewriting1647243prewriting
priesting1239483priesting
printing113216083pr_inting
probang12278383proba__ng
probation13412183probation
probations14311073probations
probative1649173probative
probing123314443pro__bing
procaine12312273proca_ine
procuring1437993procuring
prodding13189343pro_dding
producing1556143producing
profiling1548233profiling
progging132610383pro_gging
programings1753413programings
programming1954193programming
projecting22177243projecting
prolactin1347763prolactin_
prolactins1447143prolactins
prolamin12139753prolamin_
prolamine131510563prolamine
prolamins13159693prolamins
prolapsing1543873prolapsing
prologing1338953prologing
promising14410973promising
promoing13310463pro_moing
pronation11415703pronation
pronations12314033pronations
pronging123511843pro_nging
proofing1439313pro_ofing
propagating1754883propagating
propining14310133propining
proponing1439993proponing
proposing1439673proposing
propping122811673pro_pping
prorate9418733prorat__e
prorated11513713prorat_ed
prorates10418073prorat_es
proroguing1443123proroguing
prosecting15189813prosecting
prosing103319383pro__sing
protamin121210543protamin_
protamine131310913protamine
protamins131410773protamins
protatic12314743protati_c
protecting151910213protecting
protesting131910253protesting
protonating1448583protonating
protruding1453633protruding
providing1637963providing
proving134214073pro__ving
provoking1935133provoking
prowling1449993pro_wling
pulsating1236343pulsating
pupating1337683p_upating
purporting1543793purpor_ting
rating74938703___rating
rebating112418343_rebating
recrating121318793recrating
redating102620173_redating
regrating111316213regrating
relating92725443_relating
remating112322413_remating
reprobating1647103reprobating
roaming103215793_ro_aming
roaring82916003_ro_aring
roasting93012693_roasting
roosting93411453_roosting
rooting83522433_ro_oting
rotting82919683_ro_tting
rousting93913273_rousting
routing83821093_ro_uting
serrating10513203serrating
shorting122514803shor_ting
snorting92613373snor_ting
solating9315593_solating
sorting83221813_sor_ting
sporting112415463spor_ting
sprouting1236943spro_uting
throating1398393thro_ating
titrating10310113titrating
treating92519613tr_eating
troaking133310973tro_aking
trotting92510913tro_tting
uncrating12813183uncrating
uprating11311113_uprating
uprooting1276903upro_oting
urinating10310653urinating
vibrating1537473vibrating
violating1337433violating
worriting1345553worriting
worsting1267683_worsting

Search took 10 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.1561145455.1
2DLD Change Limit1486412179.11016316.2
3Display Results2172170.0932333.3
 (SQL Overall)1786912179.35919093.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.