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

77 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
trajects174453(None) 
traject1637041traject_
projects1936412projects
rejects163910692_rejects
tracts85019072tra__cts
trajected1944042trajected
transects1157822transects
trijets14308262trije_ts
trisects1035982trisects
analects1047703analects
bracts105617773bra__cts
dejects17389223_dejects
dialects11126003dialects
disjects18275923disjects
ejects15409953__ejects
erects84116183er__ects
injects16257453_injects
introjects1953703introjects
objects18123693_objects
praefects1642873praefects
praelects1354353praelects
prefects1598133prefects
prelects1299723prelects
project1838453project_
projets1639163proje_ts
prosects1239473prosects
protects1239743protects
rajes125022783_raje__s
ramets83517393_rame_ts
ramjets1635163_ramje_ts
reejects17336083reejects
refects124012743_refects
reject154116283_reject_
resects94115593_resects
subjects19226533subjects
tacts76524123t_a__cts
tajes124920693t_aje__s
talents7312013t_alents
targets84314223targe_ts
trabeate1049483trabeate
tracers94917843trace_rs
traces85329933tra__ces
tracks124818843tra__cks
tract75635713tra__ct_
traders84316953trade_rs
trades75724503trade__s
traduces1136563traduces
tragics10338083tragic_s
traits65121983tra__its
trajecting2044293trajecting
trajection1944693trajection
trajections2044513trajections
trajectory2252563trajectory
tramells10327833tramells
tramels93812493trame_ls
trances93919643tra_nces
transacts1157363transacts
transect10410053transect_
transepts1146383transepts
transfects1545723transfects
transits8313503transits
trapes85024463trape__s
trapeses1039153trapeses
trapezes1936543trapezes
trapnests1144433trapnests
travels104711293trave_ls
traves94222743trave__s
travesty1444483travesty
treats64821693tr__eats
trets55928023tr__e_ts
trevets10499973treve_ts
tridents938583tridents
trifecta1343573trifecta
trifectas1443653trifectas
trijet133916553trije_t_
trisect939733trisect_
trivets103911583trive_ts

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.423422437.4
2DLD Change Limit146162776.42022766.7
3Display Results77770.0332333.3
 (SQL Overall)178691776.87625987.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.