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

132 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
tracheid143758(None) 
tracheids1545051tracheids
arachnid1455592arachnid
traced94821582trac_e_d
trachea12311682trache_a
tracheae1349112tracheae
tracheal1348252tracheal
tracheas13410272tracheas
trachled1438312trachled
tracked143716132tracke_d
trashed113514702trashe_d
trichoid1457812trichoid
trochoid1468442trochoid
ached119227833__ache_d
arachnids1574303arachnids
arachnoid1544513arachnoid
araneid8310803ara_neid
arched125717323ar_che_d
attached14165703attache_d
bached145519893_bache_d
beached154516553beache_d
braced115420603brac_e_d
braches144621223brache_s
brachet144020313brache_t
brachets154311983brachets
brachia141910423brach_ia
braconid1345633braconid
bracted12410933bracte_d
branched163210453branche_d
breached163411643breache_d
broached16309123broache_d
cached145419203_cache_d
coached153313843coache_d
cracked163514743cracke_d
crackhead2143323crackhead
cranched163210413cranche_d
crashed134214203crashe_d
fracted1339373fracte_d
graced105217903grac_e_d
graphed1498473graphe_d
leached133715043leache_d
marched153813403marche_d
orache114013593orache__
oraches124216473orache_s
orchid1289573or_ch_id
parched154013693parche_d
peached154315883peache_d
poached154212403poache_d
preached163412063preache_d
prochein1547523prochein
raced87635313_rac_e_d
rachet115028973_rache_t
racheted14149503_racheted
rachets124516833_rachets
rachis114017653_rach_is
racked134526083_racke_d
ranched133113603_ranche_d
reached134619083reache_d
roached133211833roache_d
ruched124314633_ruche_d
starched14199313starche_d
tache106222373t_ache__
taches114224173t_ache_s
tachinid1446243t_achinid
tacked134723943t_acke_d
teacher123714833teache_r
teachers133212393teachers
teaches122718353teache_s
teched124014433t_eche_d
tetched133010773tetche_d
thacked173810203thacke_d
thatched1735433thatche_d
thrashed1555363thrashe_d
torched133511363torche_d
touched134914963touche_d
trace75829613trac_e__
tracer84820233trac_e_r
traceried1247143traceried
tracers94917843trac_ers
tracery12399793trac_ery
traces85329933trac_e_s
tracheary1744803tracheary
tracheate1448233tracheate
tracheated1646333tracheated
tracheitis1543923tracheitis
tracheole1445573tracheole
trachle12311853trach_le
trachles13311753trachles
trachling1537823trachling
trachoma15116623trachoma
trachyte1645943trachyte
trachytic1944183trachytic
tracker133515173tracke_r
trackers143512853trackers
trackpad1743373trackpad
trackside1644373trackside
traded85717683tra_de_d
traiked123310453traike_d
trailed83415673traile_d
trailhead1343423trailhead
trained84117203traine_d
trammed123810713tramme_d
tramped124312433trampe_d
tranced104414173trance_d
tranche123312223tranche__
tranches132915513tranche_s
trapped124512213trappe_d
trasher104416133trashe_r
trashers113013643trashers
trashes104119263trashe_s
trashier113210103trashier
trauchled1543733trauchled
trawled113411523trawle_d
treachery1744693treachery
trenched14289853trenche_d
triacid1038593triac__id
triced95518673tric_e_d
tricked144016163tricke_d
trochaic1546943trochaic
troche113112513troche__
trochee122613883troche_e
trochees132510183trochees
troches123715343troche_s
trochil1258713troch_il
trochoids1546603trochoids
trocked144312243trocke_d
trophied1437643trophied
trothed114010973trothe_d
truced95312053truc_e_d
trucked143910813trucke_d
wracked174110113wracke_d
wrathed14298523wrathe_d

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.436409841.7
2DLD Change Limit1461621328.03018202.0
3Display Results1321320.0502640.0
 (SQL Overall)1786911328.51620983.0
 
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.