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

184 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
probating1431119(None) 
pronating12313761pronating
prorating12314281prorating
approbating1844582approbating
bromating1439182bromating
perorating13313132perorating
phonating1537812phonating
prating103424452pr__ating
prebaking1838062prebaking
predating13514652predating
probang12278382proba__ng
probation13412182probation
probations14311082probations
probative1649172probative
probing123314442prob__ing
profaning1537292profaning
profiting1549982profiting
promoting1439922promoting
prompting1637202prompting
rebating112418342_rebating
reprobating1647102reprobating
rotating92614552_rotating
abating10413973__abating
abrogating1497983abrogating
arointing1049363arointing
aroynting1344633aroynting
arrogating121778393arrogating
bating95132253___bating
bloating113512813blo_ating
boating103721303_bo_ating
borating113414503_borating
brocading1556253brocading
browbeating1952363browbeating
coating103525313_co_ating
cohobating1845023cohobating
combating16310163combating
coronating13410173coronating
corotating1349323corotating
crating103725203cr__ating
creating113921953cr_eating
cremating14312203cremating
croaking153712163cro_aking
debating123213733_debating
derogating1348633derogating
doating93816863_do_ating
donating10311803_donating
floating123111883flo_ating
fronting12310443fro_nting
frosting12311183fro_sting
frowsting1634683frowsting
gloating102611463glo_ating
gradating1237323gradating
grating93923183gr__ating
groaning102410283gro_aning
grouting103410793gro_uting
iodating1038823_iodating
isolating1039743isolating
locating11311503_locating
moating104218153_mo_ating
notating92513343_notating
orating83520323__orating
orbiting1138153or_biting
ozonating1944323ozonating
palpating1438543palpating
parbaking1877203parbaking
percolating1657323percolating
perforating1747023perforating
permeating1539923permeating
personating1447673personating
pirating11314513p_irating
placating1438513placating
plating103823073p__lating
pleating112916053p_leating
plotting113011013plo_tting
pointing112813683p_ointing
pomading1437423p_omading
portaging1346843portaging
porting103021783p_o_rting
positing11312303p_ositing
posting105622243p_o_sting
potting103720893p_o_tting
pouting103519943p_o_uting
praying133717323pr__aying
preacting142412533preacting
prebuying1734303prebuying
precasting15169833precasting
prefacing17118743prefacing
prefading16149033prefading
preheating16310723preheating
prelocating1647413prelocating
preobtain1343993preobtain_
preobtains1443823preobtains
preparing14311643preparing
prepasting15168883prepasting
prepaving1787233prepaving
prepaying1747973prepaying
presaging1339393presaging
pretaping1439133pretaping
pretasting13239283pretasting
priesting1239483priesting
printing113216083pr_inting
proband122710243proba__nd
probangs13256213proba__ngs
probate11414483probat__e
probated13410863probat_ed
probates12414283probat_es
probational1547083probational
probationer1563773probationer
probatory1647113probatory
probities13312653probities
procaine12312273proca_ine
procreating1647693procreating
procuring1437993procuring
prodding13189343pro_dding
producing1556143producing
profiling1548233profiling
progging132610383pro_gging
programing1646313programing
prohibiting1953933prohibiting
projecting22177243projecting
prolactin1347773prolactin_
prolactins1447153prolactins
prolamin12139753prolamin_
prolamine131510563prolamine
prolamins13159703prolamins
prolapsing1543873prolapsing
prologing1338953prologing
promising14410973promising
promoing13310463pro_moing
pronation11415703pronation
pronations12314033pronations
pronging123511843pro_nging
proofing1439313pro_ofing
propagating1754883propagating
propining14310133propining
proponing1439993proponing
proposing1439673proposing
propping122811673pro_pping
proration11415983proration
prorations12314463prorations
prorogating1556063prorogating
prosecting15189813prosecting
prosing103319383pro__sing
prostrating1449393prostrating
protamin121210543protamin_
protamine131310913protamine
protamins131410773protamins
protatic12314753protati_c
protecting151910213protecting
protesting131910253protesting
protonating1448593protonating
protracting1646933protracting
providing1637963providing
proving134214073pro__ving
provoking1935133provoking
prowling1449993pro_wling
pulsating1236343pulsating
pupating1337683p_upating
rating74938703_r__ating
rebaiting12311643_rebaiting
redating102620173_redating
relating92725443_relating
remating112322423_remating
roaming103215793_ro_aming
roaring82916003_ro_aring
roasting93012703_roasting
robbing123313213_rob_bing
robing93618003_rob__ing
roosting93411463_roosting
rooting83522433_ro_oting
rotting82919683_ro_tting
rousting93913273_rousting
routing83821093_ro_uting
solating9315593_solating
sprouting1236943spro_uting
throating1398403thro_ating
treating92519613tr_eating
troaking133310973tro_aking
trotting92510913tro_tting
unabating1246753unabating
uprating11311113upr__ating
uprooting1276903upro_oting
urinating10310653urinating
violating1337443violating

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411846.54622707.1
3Display Results1841840.0931978.5
 (SQL Overall)1786911847.09225196.1
 
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.