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

84 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
projected2116582(None) 
prosected14158631prosected
protected14158651protected
prelected1439132prelected
project1838452project__
projector20186682projector
projects1936412project_s
prosecuted1544282prosecuted
prospected1744872prospected
protecter13179102protecter
protested12159112protested
rejected182710112_rejected
trajected1944042trajected
corrected1438113corrected
dejected19307593_dejected
disjected2086353disjected
ejected17297653__ejected
erected103213993er__ected
injected18226753_injected
introjected2153193introjected
objected2043493_objected
perfected1736643perfected
pirouetted1342943pirouetted
praelected1544393praelected
preacted132710943pr_eacted
precented14310693precented
precited133013813pr__ecited
predicted1538913predicted
preelected1545783preelected
preerected1545573preerected
preheated1539813preheated
presented12311633presented
pretested12149113pretested
pretexted19135693pretexted
prevented1539003prevented
priested1138393pr_iested
probated13410863pro_bated
proceed12310553pro__ceed
proceeded1544103proceeded
processed1446803processed
procreated1546443procreated
produced1456073produc_ed
proette9312363pro_ette_
proettes10312763pro_ettes
professed1545243professed
profited14279973pro_fited
projectile2144553projectile
projectiles2243803projectiles
projecting22177243projecting
projection2158763projection
projective2446813projective
projectors21187173projectors
projet15315183proje_t__
projets1639163proje_t_s
promoted13310543pro_moted
prompted1536903pro_mpted
pronated11414053pro_nated
propelled1456913propelled
propended1546163propended
propertied15137253propertied
prorated11513713pro_rated
prosect11313393prosect__
prosector13208533prosector
prosects1239473prosect_s
prosecute1345953prosecute_
prosecutes1445673prosecutes
proselyted1643433proselyted
protect11313633protect__
protecters14168253protecters
protector13169533protector
protects1239743protect_s
protended1336803protended
protester111510483protester
protracted1545763protracted
proverbed1743813proverbed
reejected1955093reejected
refected142311663_refected
rejectee17289623_rejectee
rejecter17258943_rejecter
reobjected2242253reobjected
resected112514743_resected
subjected2144773subjected
trisected1244913trisected
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 Limit148641847.48619855.9
3Display Results84840.0431953.5
 (SQL Overall)178691847.93522519.3
 
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.