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

120 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
torchon123736(None) 
torchons1337501torchons
archon11311752_archon
torch107420932torch__
torched133511352torched
torches123715432torches
torching142510082torching
torchy14549532torch_y
torsion7310802torsion
archons12311583_archons
barchan1469133barchan
birchen14347883birchen
boron76727143bor__on
chon96627793___chon
cochin131313203co_chin
cocoon10312263co_coon
coercion1246573coercion
concho134414263concho_
conchos144313963conchos
cordon95017293cor_don
cornichon1642883cornichon
garcon92912483garc_on
gorgon8310243gor_gon
gorhen1038893gor_hen
honcho14389383honcho_
honchos15369573honchos
horizon1955763horizon
kerchoo1644973kerchoo
larchen12479623larchen
lochan1139093lo_chan
lorgnon844423lorgnon
marchen143312073marchen
morion86217733mor_ion
moron76925423mor__on
morphin1439003morphin
morpho13158443morpho_
morphos14159083morphos
morrion959003morrion
ochone11311293_o_chone
orcein838183_orcein
orchid1289573_orchid
orchil1158653_orchil
orchis11710773_orchis
orcin72716573_orc_in
orison6411663_orison
orlon5415003_or_lon
orphan1137733_orphan
ortho8312293_ortho_
poncho133310123poncho_
ponchos143410703ponchos
porch125918623porch__
porches143815673porches
porcino1138113porcino
portion9615493portion
soochong14104373soochong
sorgho10348713sorgho_
sorghos11327603sorghos
souchong1484513souchong
tachyon1544623t_achyon
tardyon1134673tardyon
tarpon82812803tar_pon
techno1135953t_echno
ternion739493ternion
thoron94713903thor__on
tocher114014913to_cher
tocsin8311003to_csin
toeshoe1047843toeshoe
tomcod1135783tomc_od
tompion11247103tompion
toon47740633to___on
torah87125273torah__
torahs95115643torah_s
torc66333353torc___
torchere1347683torchere
torchier1337463torchier
torchwood1853103torchwood
torcs75123763torc__s
torero6313203torero_
toreros7311343toreros
torn46044253tor___n
toro48045683tor__o_
toros54336193tor__os
torot56139943tor__ot
torpor839193tor_por
torsions839183torsions
torso56922143tor_so_
torsos64815733tor_sos
torten65314353tor_ten
tortoni738033tor_toni
toucan838193touc_an
touch106519393touch__
touchdown1852173touchdown
touche114916173touch_e
touched134914963touched
toucher124814353toucher
touches125118343touches
touching143211343touching
touchtone1443973touchtone
touchup1443833touchup
touchy145010503touch_y
toughen11329203toughen
toyon86715673to__yon
toyshop1544873toyshop
trigon74513103t_rigon
triton63914893t_riton
trochal1288243trochal
trochar1257073trochar
troche113112513troch_e
trochee122613883trochee
troches123715343troches
trochil1258713trochil
trochoid1468443trochoid
trogon73611753t_rogon
tuchun1145443t_uchun
turion6313163tur_ion
turnon638193tur_non
tycoon1136023t_ycoon
typhon1436673t_yphon
urchin1138743_urchin
zircon1754953zirc_on

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271206.18621666.2
3Display Results1201200.0462608.7
 (SQL Overall)1786911206.63826919.4
 
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.