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

98 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
tracheae134911(None) 
trachea12311681trachea_
tracheal1348251tracheal
tracheas13410271tracheas
tracheate1448231tracheate
drachmae1643932drachmae
tracheary1744802tracheary
tracheated1646332tracheated
tracheates1547922tracheates
tracheid1437582tracheid
tracheole1445572tracheole
trachle12311852trach_le
trachyte1645942trachyte
trochee122613882troche_e
trochleae1444172trochleae
achene11313813__achene
archean1269123ar_chean
braches144621223brache_s
brachet144020313brache_t
brachets154311983brachets
brachia141910423brachia_
brachial15219303brachial
brachiate1646873brachiate
bracteal1245563bracteal
bracteate1345353bracteate
branchiae16186313branchiae
crackhead2143323crackhead
drachma1544303drachma_
drachmai1653243drachmai
drachmas1644863drachmas
grapheme1644013grapheme
machete14310883_machete
marchese15358913marchese
orache114013593orach__e
oraches124216473orache_s
raceme1039733_rac_eme
rachet115028973_rache_t
racheted14149503_racheted
rachets124516833_rachets
rachial122012173_rachial
raphae114311733_raph_ae
recheat12415933_recheat
tache106222373t_ach__e
taches114224173t_ache_s
teacher123714833teache_r
teachers133212393teachers
teaches122718353teache_s
torchere1347683torchere
trabeate1049483tra_beate
trace75829613trac___e
traceable1338323trac_eable
traced94821583trac_e_d
tracer84820233trac_e_r
tracers94917843trac_ers
tracery12399793trac_ery
traces85329933trac_e_s
tracheids1545053tracheids
tracheolar1552613tracheolar
tracheoles1545623tracheoles
trachled1438313trachled
trachles13311753trachles
trachoma15116623trachoma
trachomas16126413trachomas
trachytes1745923trachytes
trackage1545653trackage
tracked143716133tracke_d
tracker133515173tracke_r
trackers143512853trackers
trackman1645403trackman
trackpad1743373trackpad
trackway20113783trackway
tractate10411003tractate
tractile10311073tractile
tractive13310043tractive
trailhead1343423trailhead
trainee72817793traine_e
tranche123312223tranch__e
tranches132915513tranche_s
trapeze1836253tra_peze
trappean1244393trappean
trashed113514703trashe_d
trasher104416133trashe_r
trashers113013643trashers
trashes104119263trashe_s
trashman1345813trashman
trauchle1344963trauch_le
treachery1744693treachery
trichinae1444703trichinae
trichite1349333trichite
trichome1596953trichome
trochal1288243troch_al
trochar1257073troch_ar
troche113112513troch__e
trochees132510183trochees
troches123715343troche_s
trochlea1345193trochlea_
trochlear1443453trochlear
trochleas1444713trochleas

Search took 9 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 Limit146162987.55019359.2
3Display Results98980.0462130.4
 (SQL Overall)178691988.01622291.8
 
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.