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

165 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
prophets153950(None) 
prophet14316031prophet_
propjets1935491propjets
crochets15359832crochets
droplets1136062droplets
poppets10338852p_oppets
projets1639162pro_jets
propels113412842prop_els
propers113619032prop_ers
prophecy2043912prophecy
prophesy1844452prophesy
prophetess1744242prophetess
prophetic18710582prophetic
propjet1839912propjet_
rochets124213472_rochets
brachets154311983brachets
brockets16328123brockets
brothels13277073brothels
brothers133410833brothers
crochet143616663crochet_
crockets16339543crockets
cropless1237793cropless
croppers143311483croppers
croquets1955213croquets
crotchets16396303crotchets
crownets13407673crownets
drophead1544613drophead
dropheads1643873dropheads
droplet10312113droplet_
dropouts1145003dropouts
droppers13318603droppers
dropshots1543393dropshots
freshets14298673freshets
froglets1235263froglets
frothers14279813frothers
gophers1338983_gophers
grommets13234663grommets
gropers104813853grop_ers
gropes95220403grop_e_s
moppets13307163_moppets
nymphets1862703nymphets
pamphlets1842753pamphlets
parapets1239763parap_ets
paroquets2043643paroquets
peoplers1237163peoplers
peoples11312223people_s
piolets93513193pio_lets
pipets105714773p_ip_ets
pockets154612253p_ockets
poets76024443p_o__ets
pooches143214163pooche_s
popes95933813p_op_e_s
poppers103414863p_oppers
poppet92717323p_oppet_
porches143815673porche_s
poshest12312423p_oshest
possets94212773p_ossets
pothers123818623p_others
preheats1339413pr_eheats
prepregs13144763prepregs
prepress12137983prepress
presets94216423pr_esets
prickets16329083prickets
privets122910053pr_ivets
probates12414283probates
probers113514583pro_bers
probes104119453pro_be_s
probits112712573pro_bits
problems1434343problems
proceeds1335983proceeds
process11310403pro_cess
prochein1547523prochein
prodders1237463prodders
products1376513products
proems104711163pro__ems
proettes10312763proettes
profess1237713pro_fess
proffers16126593proffers
profits122911243pro_fits
proggers12258163proggers
progress1137023progress
projects1936413projects
projet15315183pro_jet_
prolegs10379993pro_legs
proles84627203pro_le_s
promotes12314123promotes
prompters1537553prompters
promptest1546063promptest
prompts1337473pro_mpts
pronates10418373pronates
proofers13118363proofers
propanes122415823propanes
propel103714063prop_e_l
propend123311273prop_end
propends13249173propends
propene112716043prop_ene
propenes122816513propenes
propense122410103prop_ense
proper104319953prop_e_r
properest1349663properest
property1547073property
prophage1649433prophage
prophages1749763prophages
prophase15410243prophase
prophases16411063prophases
prophecies1996503prophecies
prophesies17107893prophesies
propines122618933propines
propmen1338763propme_n
propolis12311403propolis
proponents1445803proponents
propones122516963propones
proposers13228523proposers
proposes122515973proposes
propped113311953proppe_d
propretor1345533propretor
propretors1445793propretors
propriety1645433propriety
props95726883prop___s
propyls14308193prop_yls
prorates10418073prorates
prosects1239473prosects
prosers94219643pro_sers
proses84733473pro_se_s
prosiest10416523prosiest
prospects1545103prospects
prospers123012263prospers
prosses94019513prosse_s
proteas92015123pro_teas
protects1239743protects
protest9317533pro_test
protests10310493protests
proteus92511593pro_teus
protheses1449073protheses
prothesis1449433prothesis
prothetic161010073prothetic
protists10313363protists
proudest1138943proudest
provers123817793pro_vers
proves114322253pro_ve_s
provosts1336083provosts
prowess1237903pro_wess
prowest12311533pro_west
prowlers13328933prowlers
proxies163014933proxie_s
puppets10317013p_uppets
pyropes142210193pyrop_e_s
rachets124516833_rachets
raphes115117453_raphe_s
rochet115423003_rochet_
rockets134615363_rockets
ropers84325903_rop_ers
ropes75940063_rop_e_s
ropiest93317773_ropiest
roquets16398943_roquets
rosets65819953_ro_sets
sprockets1743253sprockets
strophes13310603strophe_s
tophes115218423_tophe_s
triplets103510263triplets
trippets12357423trippets
trochees132510183trochees
troches123715343troche_s
tropes84824353trop_e_s
trophies13413673trophies

Search took 7 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 Filter1786911461620.406440125.6
2DLD Change Limit1461621656.50022486.5
3Display Results1651650.0802062.5
 (SQL Overall)1786911656.98625578.4
 
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.