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

101 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
traject163704(None) 
trajects1744531trajects
project1838452project
reject154116282_reject
tract75635712tra__ct
trajected1944042trajected
transect10410052transect
trijet133916552trije_t
trisect939732trisect
abject17137703_abject
bract96332723bra__ct
bravest124211753bravest
brawest123810483brawest
deject164512843_deject
dialect101210263dialect
disject17268673disject
eject145016043__eject
erect74129333er__ect
gravest114011633gravest
grayest11489363grayest
inject153210233_inject
introject1844833introject
iratest7312483iratest
object17135803_object
praefect1544773praefect
praelect1247533praelect
prefect141011073prefect
prelect111013833prelect
projects1936413projects
projet15315183proje_t
prosect11313393prosect
protect11313633protect
rajes125022783_raje_s
ramet75743143_rame_t
ramjet15311543_ramje_t
rarest65725483_rarest
rawest93615063_rawest
reeject16349623reeject
refect114319333_refect
rejects163910693_rejects
resect84424703_resect
subject18258633subject
tacet75840023t_ace_t
tact67349033t_a__ct
tajes124920693t_aje_s
talent6323323t_alent
tamest85721293t_amest
target75028903targe_t
tartest72517533tartest
trabeate1049483trabeate
trace75829613tra__ce
traced94821583trace_d
tracer84820233trace_r
tracers94917833tracers
tracery12399793tracery
traces85329933trace_s
track114823013tra__ck
tracts85019073tra__cts
trade65026043trade__
traded85717683trade_d
trader75218753trade_r
traders84316943traders
trades75724493trade_s
traduce1036343traduce
tragedy1234793tragedy
tragic93811543tragic_
tragics10338083tragics
trait56940843tra__it
trajecting2044293trajecting
trajection1944693trajection
trajectory2252563trajectory
tramel84113713trame_l
tramell9398703tramell
tramels93812493tramels
trance84718763tra_nce
tranced104414173tranced
trances93919643trances
transact1049823transact
transects1157823transects
transept1048633transept
transfect1446733transfect
transit7317163transit
trapes85024463trape_s
trapeze1836243trapeze
trapnest10310923trapnest
trapt76433393tra__pt
trave85223033trave__
travel94112983trave_l
travels104711293travels
traves94222743trave_s
travesty1444483travesty
treat56240353tr__eat
tret46653533tr__e_t
trevet94818913treve_t
trident8314193trident
trifecta1343573trifecta
trijets14308263trijets
trisects1035983trisects
tritest7315273tritest
trivet93721883trive_t
truest64816193tr_uest

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.1731032896.0
2DLD Change Limit1340271016.95319276.1
3Display Results1011010.0303366.7
 (SQL Overall)1786911017.15624970.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.