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

102 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
prosected1415863(None) 
projected21165821projected
prosecuted1544281prosecuted
prospected1744871prospected
protected14158651protected
prelected1439132prelected
presented12311632presented
prosect11313392prosect__
prosector13208532prosector
prosects1239472prosect_s
prosecute1345952prosecute_
prosecutes1445672prosecutes
proselyted1643432proselyted
protecter13179102protecter
protested12159112protested
resected112514742_resected
trisected1244912trisected
bisected1336203_bisected
closeted1135613close_ted
corrected1438123corrected
corseted11311473corse_ted
dissected13108663dissected
erected103213993er__ected
exsected1835673_exsected
frosted113211883fros__ted
perfected1736643perfected
persecuted1543503persecuted
pirouetted1342943pirouetted
posited10511493p_os_ited
posted93722493p_os__ted
praelected1544393praelected
preacted132710943pr_eacted
precented14310693precented
precited133013813pr__ecited
predicted1538913predicted
preelected1545783preelected
preerected1545573preerected
preheated1539813preheated
preselected1643963preselected
presentee11411863presentee
presenter11311643presenter
preserved15107563preserved
presettled1344083presettled
presifted1536873presifted
presorted1239453presorted
pretested12149113pretested
pretexted19135693pretexted
prevented1539003prevented
priested1138393pr_iested
probated13410863pro_bated
proceed12310553pro__ceed
proceeded1544103proceeded
processed1446803processed
procreated1546443procreated
produced1456073produc_ed
proette9312363pro_ette_
proettes10312763pro_ettes
professed1545243professed
profited14279973pro_fited
project1838453project__
projector20186683projector
projects1936413project_s
promoted13310543pro_moted
prompted1536903pro_mpted
pronated11414053pro_nated
propelled1456913propelled
propended1546163propended
propertied15137263propertied
prorated11513713pro_rated
prosecting15189813prosecting
prosectors14199123prosectors
prosecutor1444413prosecutor
prosed94921103pros___ed
proselyte1444843proselyte_
proselytes1544743proselytes
prospect1447893prospect__
prospector1644363prospector
prospects1545103prospect_s
prospectus1643413prospectus
prospered1446973prospered
prostate10314533prostate_
prostates11314423prostates
prostrated1349423prostrated
protect11313633protect__
protecters14168263protecters
protector13169533protector
protects1239743protect_s
protended1336803protended
protester111510483protester
protracted1545763protracted
proverbed1743813proverbed
refected142311663_refected
rejected182710113_rejected
reseated93220263_reseated
resented92716963_resented
respected1438493_respected
roseate7613453_roseate_
rosette7310373_rosette_
rosettes8310343_rosettes
trajected1944043trajected
transected1347313transected
unprotected1652753unprotected

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.406440125.6
2DLD Change Limit1486411026.69022218.4
3Display Results1021020.0432372.1
 (SQL Overall)1786911027.13925030.3
 
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.