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 “torch” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

94 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
torch10742093(None) 
porch125918621porch
torah87125271torah
torc66333351torc_
torchy14549531torchy
torcs75123761torcs
touch106519391touch
arch98628442_arch
birch124914022birch
borsch1336132borsch
botch126717452botch
coach125919452coach
conch124620072conch
cooch124916832cooch
couch125320112couch
curch124415412curch
force105324272force
forth116222672forth
hooch135813702hooch
horah117922042horah
hotch136214722hotch
larch105919792larch
loach105116362loach
loch95527132lo_ch
lurch104814632lurch
march125622892march
merch125417962merch
mooch125313612mooch
morph121712512morph
mouch124715802mouch
north86018272north
notch105613322notch
orach105219232_orach
orc57034922_orc_
orca65522772_orca
orcs67025432_orcs
ouch95724632_ouch
parch125123002parch
perch124518832perch
poach124917862poach
pooch124815302pooch
pouch124617082pouch
roach105717002roach
rotch105815932rotch
scorch13198092scorch
starch113013202starch
tach96132752t_ach
teach105221122teach
tech95925442t_ech
tench105620002tench
terce75721842terce
teuch105214852teuch
tooth88020182tooth
toph96326872to_ph
tor39261682tor__
tora47545992tor_a
torahs95115642torahs
toras55540372toras
torched133511352torched
torches123715432torches
torchon1237362torchon
tore47359322tor_e
tores55352672tores
tori47542152tor_i
toric76529312toric
torics85118352torics
torii55521592torii
torn46044252tor_n
toro48045682tor_o
toros54336192toros
torot56139942torot
toroth95512962toroth
torr45630902tor_r
torrs53923562torrs
tors46157382tor_s
torse55833332torse
torsi57423362torsi
torsk94915772torsk
torso56922142torso
tort46967462tor_t
torta55925352torta
torte55431702torte
torts56138122torts
torus54329762torus
tory75840542tor_y
tosh74826812to_sh
touche114916172touche
touchy145010502touchy
tough97321982tough
troche113112512troche
trock114817602trock
troth85622202troth
vouch134611902vouch
worth117120522worth

Search took 3 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 Filter178691538000.0961861364.6
2DLD Change Limit53800942.07625915.2
3Display Results94940.0165875.0
 (SQL Overall)178691942.18881668.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.