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

99 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
torchere134768(None) 
torcheres1446861torcheres
torchiere1443571torchiere
tocher114014912to_cher_
tochered1437912to_chered
tochers123413092to_chers
torched133511352torche_d
torches123715432torche_s
torchier1337462torchier_
torchieres1543242torchieres
torchiers1445072torchiers
toucher124814352toucher_
touchers133611212touchers
trochee122613882troche_e
archer115016243_archer_
archers124414573_archers
archery15478063_archery
botcher143613223botcher_
botchers153511543botchers
botchery18366763botchery
bouchee143313543bouche_e
brochure1544353brochure
coacher143714123coacher_
coachers154312303coachers
cohere112716993co__here
coinhere1337133coinhere
coucher144515853coucher_
couchers153513863couchers
forcer114917343forc_er_
forcers124215713forc_ers
fourchee1645383fourche_e
lurcher12338133lurcher_
lurchers13307153lurchers
marcher143912973marcher_
marchers153710813marchers
marchese15358913marchese
moocher143610673moocher_
moochers15369123moochers
morpheme1744053morpheme
norther1039733norther_
northern1145583northern
northers1139333northers
notcher123610933notcher_
notchers13279423notchers
nowhere1337203no_where
ocher104516103_o_cher_
ochered132610283_o_chered
ochers113915303_o_chers
ochery14319443_o_chery
ochre103411593_o_ch_re
oosphere1355993oosphere
orchard1346933_orchard
percher143313423percher_
perchers153611523perchers
poacher143912323poacher_
poachers152910763poachers
poechore1547853poechore
porches143815673porche_s
portiere1038773portiere
scorcher15196783scorcher_
scorchers16145513scorchers
sorcerer1036433sorc_erer
sorcery1237023sorc_ery
teacher123714833teacher_
teachers133212393teachers
there87527393t___here
torch107420933torch___
torchable1645533torchable
torchbearer1851433torchbearer
torchiest1438033torchiest
torching142510083torching
torchlike1843713torchlike
torchon1237363torch_on
torchons1337503torchons
torchy14549533torch__y
torero6313203tor__ero
torquer16205323torquer_
torquers17204303torquers
torture738593tor_ture
tother94117143to_ther_
touche114916173touch__e
touched134914963touche_d
touches125118343touche_s
touchier1347383touchier_
tougher114210983tougher_
towhee122613883to_whe_e
tracheae1349113tracheae
trochar1257073trochar_
trochars1377853trochars
troche113112513troch__e
trochees132510183trochees
troches123715343troche_s
trochleae1444173trochleae
trouvere1144073trouvere
vouchee153411263vouche_e
voucher154110263voucher_
vouchered1843853vouchered
vouchers16418623vouchers
zoochore2245783zoochore

Search took 10 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.1561145455.1
2DLD Change Limit146162999.39015565.7
3Display Results99990.0303300.0
 (SQL Overall)178691999.57618660.3
 
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.