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

230 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
prosect1131339(None) 
project1838451project
prosects1239471prosects
prospect1447891prospect
protect11313631protect
porrect1159742porrect
prefect141011072prefect
prelect111013832prelect
present94022732present
preset84430982prese_t
product1279232product
projects1936412projects
projet15315182proje_t
prose75835122prose__
prosected14158632prosected
prosector13208532prosector
prosecute1345952prosecute
prosed94921092prose_d
proser84223462prose_r
prosers94219642prosers
proses84733472prose_s
prosiest10416522prosiest
prosit85124592pros_it
prospects1545102prospects
prost75434102pros__t
protects1239742protects
protest9317532protest
prowest12311532prowest
resect84424702_resect
roset55945242_rose_t
trisect939732trisect
acrolect1247423acrolect
arose55832083arose__
avoset9315673avose_t
bisect10312873_bisect
brose75227033brose__
broses86524403brose_s
closest94312533closest
closet85226603close_t
correct11513983correct
corset85636223corse_t
cosec96320183_cosec_
cosecs105015213_cosecs
coset75748843_cose_t
crosscut1245253crosscut
crossest1012012123crossest
cruset84425093cruse_t
dissect103614133dissect
drosera836203drosera
erect74129333er__ect
erodent8313823erodent
erose55727273erose__
erosely1038083erosely
eroses65327053erose_s
exsect1558503_exsect
frost84727833fros__t
grossest93810093grossest
insect83916583_insect
loosest75811563loosest
pandect12310953pandect
parsec105914483parsec_
parsecs11429923parsecs
perfect141010833perfect
piolet83225643piole_t
poet65552903p_o_e_t
polecat11313143p_olecat
ponent82821593p_onent
poorest9312773poorest
porose84818743porose__
portent93619643portent
pose66441733p_ose__
posed85828413p_ose_d
poser75128773p_ose_r
posers84223973p_osers
poses74642763p_ose_s
poseur8419403p_oseur
poshest12312423p_oshest
posit75833333p_os_it
posset84923253p_osset
post67953363p_os__t
potent84223353p_otent
praefect1544773praefect
praelect1247533praelect
prase76128753prase__
prases84429023prase_s
preact103220393pr_eact
precent113520263precent
precept133112513precept
precut102016533pr__ecut
predict12315323predict
preelect1249643preelect
preerect1259273preerect
prefects1598133prefects
preheat12413893preheat
prelects1299723prelects
premeet11615153premeet
prese75228383prese__
preselect1346983preselect
presell939303presell
presence122213513presence
presents103315643presents
presets94216423presets
presift12312223presift
presort95219543presort
prest75736353pr__est
pretest9517633pretest
pretext1639663pretext
prevent124016553prevent
priest84125423pr_iest
prise74632613prise__
prised94322203prise_d
prisere9310943prisere
prises84133173prise_s
privet113821343prive_t
probe94320813probe__
probed114114823probe_d
prober104516073probe_r
probers113514583probers
probes104119453probe_s
probit103218353pro_bit
proceed12310553proceed
process11310403process
produce1267513produce
products1376513products
proem94818273pro_e_m
proems104711163pro_ems
proette9312363pro_ette
profess1237713profess
profit113016273pro_fit
progeny1389463progeny
projected21165823projected
projector20186683projector
projets1639163projets
prole74527793prole__
proleg94612113prole_g
prolegs10379993prolegs
proles84627203prole_s
prompt12313013pro_mpt
prone75332623prone__
pronely12310253pronely
propel103714063prope_l
propels113412843propels
propend123311273propend
propene112716043propene
proper104319953prope_r
propers113619033propers
property1547073property
prophecy2043913prophecy
prophet14316033prophet
propjet1839913propjet
pros65742783pros___
prosaic11311163prosaic
prosaist10611583prosaist
prosecting15189813prosecting
prosectors14199123prosectors
prosecuted1544283prosecuted
prosecutes1445663prosecutes
prosecutor1444413prosecutor
proselyte1444843proselyte
prosier93817483prosier
prosily12611633prosily
prosing103319383prosing
proso77222413pros__o
prosody1336433prosody
prosoma11310223prosoma
prosos85718553pros_os
prospected1744873prospected
prospector1644363prospector
prospectus1643413prospectus
prosper114012193prosper
prospers123012263prospers
pross76529403pros__s
prosses94019513prosses
prossie91812953prossie
prostate10314533prostate
prostie91617743prostie
prosy106319253pros__y
protea82214763prote_a
protean92412193protean
proteas92015123proteas
protected14158653protected
protecter13179103protecter
protector13169533protector
protege1059153protege
protei82615313prote_i
proteid103513673proteid
protein92414733protein
protend104012793protend
protests10310493protests
proteus92511593proteus
protist9320223protist
protract12510603protract
proudest1138943proudest
prove104823193prove__
proved125016033prove_d
proven114314773prove_n
prover113819723prove_r
proverb14378213proverb
provers123817793provers
proves114322253prove_s
provost1238573provost
prower114218123prowe_r
prowess1237903prowess
prudent10310433prudent
ptoses83514673ptose_s
pyoses114314303pyose_s
pyrostat1347163pyrostat
refect114319333_refect
reject154116283_reject
reseat64131493_reseat
resects94115593_resects
resent63833623_resent
reset55051863_rese_t
respect11412033_respect
rodent7519243_rodent
rose46148903_rose__
roseate7613453_roseate
rosed65930343_rose_d
rosery93813283_rosery
roses56445773_rose_s
rosets65819953_rosets
rosette7310373_rosette
rosiest73919213_rosiest
sect67443623___sect
subsect112611843subsect
traject1637043traject
transect10410053transect
trisects1035983trisects
uprose82311483uprose__
worset96726583worse_t

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272306.96619240.2
3Display Results2302300.0962395.8
 (SQL Overall)1786912307.46823927.6
 
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.