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

76 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
touchup144383(None) 
touchups1543081touchups
touch106519392touch__
touche114916172touch_e
touched134914962touched
toucher124814352toucher
touches125118342touches
touchy145010502touch_y
tuchun1145442t_uchun
bouchee143313543bouchee
brushup1443513brushup
catchup1644793catchup
cockup1635713co_ckup
couch125320113couch__
couched154115793couched
coucher144515853coucher
couches144020473couches
douceur1043113douceur
douche124613223douch_e
douched144012113douched
douches134315233douches
fuckup1733963_fuckup
ketchup1842783ketchup
lockup1434763lo_ckup
louche115212663louch_e
matchup1643513matchup
mockup1634073mo_ckup
mouch124715803mouch__
mouched153612593mouched
mouches143815963mouches
ouch95724633_ouch__
ouched124316933_ouched
ouches114322183_ouches
pouch124617083pouch__
pouched153612773pouched
pouches144116743pouches
pouchy16538663pouch_y
pushup1335273_pushup
rouche114714313rouch_e
rouches124217893rouches
roundup1044063roundup
teacup1036253teac_up
teuch105214853teuch__
tocher114014913to_cher
toecap1037323toec_ap
tophus115210363to_phus
torch107420933torch__
torched133511363torched
torches123715443torches
torchon1237363torchon
torchy14549533torch_y
tossup875293to_ssup
toucan838193touc_an
toucans937583toucans
touchers133611213touchers
touchier1347383touchier
touchily1645233touchily
touching143211343touching
touchpad1643173touchpad
tough97321993tough__
toughed123511693toughed
toughen11329203toughen
tougher114210983tougher
toughie1187593toughie
toughly14487433toughly
toughs105414993tough_s
toughy135911083tough_y
toyshop1544873toyshop
tuchuns1233983t_uchuns
tuneup835203t_uneup
turnup835093t_urnup
vouch134611903vouch__
vouched163910563vouched
vouchee153411263vouchee
voucher154110263voucher
vouches153914113vouches

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 Filter1786911340270.393454684.5
2DLD Change Limit134027767.26318453.4
3Display Results76760.0332303.0
 (SQL Overall)178691767.68923239.8
 
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.