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

153 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
torchier133746(None) 
torchiere1443571torchiere
torchiers1445071torchiers
touchier1347381touchier
botchier15287142botchier
poachier1556822poachier
pouchier1546802pouchier
starchier1436642starchier
techier1269242t_echier
tetchier1336452tetchier
tocher114014912to_ch_er
toothier1136422toothier
torched133511352torch_ed
torchere1347682torch_ere
torches123715432torch_es
torchieres1543242torchieres
torchiest1438032torchiest
torching142510082torching
toucher124814352touch_er
worthier1436712worthier
achier113914263__achier
archer115016243_arch_er
beachier1538803beachier
beechier1535633beechier
bitchier15307733bitchier
blotchier1643213blotchier
botcher143613223botch_er
bunchier1536153bunchier
catchier15329863catchier
chichier1836023chichier
churchier1944153churchier
coacher143714123coach_er
cockier154013623co_ckier
conchie143312683conchie_
conchies153214853conchies
corkier133114303cor_kier
cornier93017093cor_nier
coucher144515853couch_er
couthier13218913couthier
dorkier122810023dor_kier
doughier1335483doughier
earthier1137443earthier
forcer114917343forc__er
forkier144311593for_kier
frothier1435953frothier
gorier73719373gor__ier
gorsier83811073gor_sier
grouchier1543843grouchier
hoochie1537803hoochie_
hoochies1639603hoochies
hornier103012463hor_nier
horsier103013243hor_sier
itchier12247673_itchier
kerchief2043873kerchief
leachier1337253leachier
lordlier935363lordlier
lurcher12338133lurch_er
marcher143912973march_er
marshier1337593marshier
moocher143610673mooch_er
mothier121910213mo_thier
mouthier13208173mouthier
norther1039733north_er
notcher123610933notch_er
ocher104516103_o_ch_er
orbier839993_or_bier
orchid1289573_orchi_d
orchids1377213_orchids
orchil1158653_orchi_l
orchils1277703_orchils
orchis11710773_orchi_s
orchises1338773_orchises
patchier15319663patchier
peachier1548623peachier
percher143313423perch_er
pitchier15368273pitchier
poacher143912323poach_er
pockier153911603po_ckier
porches143815673porch_es
porkier133712343por_kier
pornier93413133por_nier
portlier1038373portlier
punchier1536413punchier
reechier1336673reechier
rockier134911883ro_ckier
scorcher15196783scorch_er
slouchier1443603slouchier
sorcerer1036433sorcerer
sorrier72313733sor_rier
stenchier1445333stenchier
stockier14217253sto_ckier
stormier1036103stor_mier
tackier133712523t_ackier
tardier859719993tar_dier
tarrier74323173tar_rier
tarsier74119253tar_sier
tartier74123263tar_tier
teacher123714833teach_er
techie11511723t_echie_
techies12513603t_echies
terrier73414963ter_rier
thatchier1743983thatchier
thornier1135323thor_nier
toastier846893toastier
tochers123413093to_ch_ers
tonier65520713to__nier
torch107420933torch___
torcheres1446863torcheres
torchlike1843713torchlike
torchon1237363torch_on
torchons1337503torchons
torchy14549533torch__y
tories65435883tor__ies
torquer16205323tor_quer
torrider936173torrider
torturer835493torturer
tother94117143to_th_er
touche114916173touch_e_
touched134914963touch_ed
touchers133611213touch_ers
touches125118343touch_es
touchiest1437083touchiest
touchily1645233touchily
touching143211343touching
tougher114210983tough_er
toughie1187593toughie_
toughies1278243toughies
towerier1137123towerier
trashier113210103trashier
trickier143010233trickier
trier54328533t_r__ier
trochar1257073troch_ar
troche113112513troch_e_
trochee122613883troch_ee
trochees132510183trochees
troches123715343troch_es
trochil1258713trochi_l
trochili1376943trochili
trochils1388583trochils
trochlea1345193trochlea
trochlear1443453trochlear
trophied1437643trophied
trophies13413673trophies
troutier8277153troutier
turfier10249793tur_fier
twitchier1753233twitchier
voucher154110263vouch_er
witchier16307883witchier
wordier112511213wor_dier
wormier12278763wor_mier
worrier102311683wor_rier
worshiper1743113worshiper
worthies14310283worthies

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621537.73318901.1
3Display Results1531530.0632428.6
 (SQL Overall)1786911537.96922423.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.