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

126 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
projects193641(None) 
project1838451project_
projets1639161proje_ts
prosects1239471prosects
protects1239741protects
prefects1598132prefects
prelects1299722prelects
products1376512products
projected21165822projected
projector20186682projector
projectors21187172projectors
projet15315182proje_t_
propjets1935492propje_ts
prosect11313392prosect_
prospects1545102prospects
protect11313632protect_
protests10310492protests
rejects163910692_rejects
trajects1744532trajects
acrolects1344333acrolects
corrects1259573corrects
dejects17389223_dejects
disjects18275923disjects
ejects15409953__ejects
erects84116183er__ects
injects16257453_injects
introjects1953703introjects
objects18123693_objects
pandects1335843pandects
perfects15107353perfects
piolets93513193piole_ts
poets76024443p_o_e_ts
polecats1248833p_olecats
porrect1159743porrect_
portents103512823portents
praefects1642873praefects
praelects1354353praelects
preacts113211363pr_eacts
precents123015043precents
precepts14268893precepts
precis103416703pr__ecis
precuts111710473pr__ecuts
predicts1339613predicts
preelects1356083preelects
preerects1345413preerects
prefect141011073prefect_
preheats1339413preheats
prelect111013833prelect_
presents103315643presents
presets94216423prese_ts
prests84021263pr__ests
pretests10310013pretests
pretexts1735603pretexts
prevents133012293prevents
priests93810863pr_iests
privets122910053prive_ts
probers113514583probe_rs
probes104119453probe__s
probits112712573pro_bits
proceeds1335983proceeds
process11310403proce_ss
produces1347903produces
product1279233product_
proems104711163pro_e_ms
proette9312363pro_ette
proettes10312763pro_ettes
profess1237713profe_ss
profits122911243pro_fits
projectile2144553projectile
projectiles2243803projectiles
projecting22177243projecting
projection2158763projection
projections2258473projections
projective2446813projective
prolegs10379993prole_gs
proles84627203prole__s
prompts1337473pro_mpts
propels113412843prope_ls
propends13249173propends
propenes122816513propenes
propers113619033prope_rs
property1547073property
prophets1539503prophets
propjet1839913propje_t_
prosected14158633prosected
prosector13208533prosector
prosectors14199123prosectors
prosecute1345953prosecute
prosecutes1445663prosecutes
prosers94219643prose_rs
proses84733473prose__s
prospect1447893prospect_
prospectus1643413prospectus
proteans102811543proteans
proteas92015123prote_as
protected14158653protected
protecter13179103protecter
protecters14168253protecters
protector13169533protector
protectors142010143protectors
proteges1149923proteges
proteids11259943proteids
proteins102114283proteins
protends113010353protends
protest9317533protest_
proteus92511593prote_us
protists10313363protists
protracts1347023protracts
proverbs15315583proverbs
provers123817793prove_rs
proves114322253prove__s
provosts1336083provosts
prowess1237903prowe_ss
prowest12311533prowest_
reejects17336083reejects
refects124012743_refects
reject154116283_reject_
reobjects2062003reobjects
resects94115593_resects
rodents8611543_rodents
rosets65819953_rose_ts
subjects19226533subjects
subprojects2451623subprojects
traject1637043traject_
trijets14308263trije_ts
trisects1035983trisects

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621266.94021060.8
3Display Results1261260.0462739.1
 (SQL Overall)1786911267.40624127.9
 
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.