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

94 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
pronators1141130(None) 
pronator10311781pronator_
pronatores1247371pronatores
donators9310402_donators
perorators1249352perorators
personators1345542personators
predators12310092predators
probatory1647112probatory
proctors12311512pro_ctors
pronates10418372pronat_es
pronations12314032pronations
rotators8310202_rotators
urinators947632urinators
abrogators1345243abrogators
arrogators1145383arrogators
creators102814423cr_eators
cremators1369833cremators
detonators1145853detonators
donator8310263_donator_
emanators1147033emanators
evocators1446713evocators
frontons1136503fron_tons
grantors93810363gran_tors
idolators1046283idolators
isolators947513isolators
locators102910433_locators
monitors10310823_monitors
nonactors1147883_nonactors
orators7313823__orators
palpators1346813palpators
percolators1545363percolators
perforators1644853perforators
permeators1447403permeators
perorator1149743perorator_
personator1245853personator_
phonates13410643phonat_es
phonathons1843453phonathons
phonations1538313phonations
piscators1347083piscators
pontons93315553p_on_tons
potatoes1039943p_otatoes
potatory1348413p_otatory
praetors1039833pr_aetors
praters94921653pr__aters
precatory1649123precatory
predator11310063predator_
predatory1547713predatory
prefatory1746693prefatory
pretors9316813pr__etors
printers103214913prin_ters
probates12414283probat_es
probations14311083probations
procreators1575713procreators
proctor11310433pro_ctor_
procurators1545173procurators
profanatory1952993profanatory
profaners14256213profaners
profiters14228313profiters
progenitors1454243progenitors
prognathous1751763prognathous
projectors21187173projectors
prolabor1284543prolabor_
promisors13236363promisors
promoters13310093promoters
prompters1537553prompters
pronate9418873pronat__e
pronated11414053pronat_ed
pronating12313763pronating
pronation11415703pronation
pronghorn1543553pronghorn
pronghorns1652903pronghorns
pronto8313993pron_to__
propagators1654223propagators
propraetors1554183propraetors
propretors1445793propretors
prorates10418073prorat_es
prorations12314463prorations
prosateurs1243063prosateurs
prosectors14199123prosectors
protectors142010143protectors
protestors12169313protestors
protons93118003pro__tons
protractors1546623protractors
pulsators1175373pulsators
relators83316143_relators
resonators1045813resonators
rogatory1246153_rogatory
rotator7310833_rotator_
rotatores946483_rotatores
rotatory1147213_rotatory
rotors64917953_ro__tors
senators8312953_senators
urinator847843urinator_
violators1246583violators

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 Limit148641947.53319732.0
3Display Results94940.0462043.5
 (SQL Overall)178691948.01522294.6
 
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.