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

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

46 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
unretouched175150(None) 
retouched1545112__retouched
untouched1544412un__touched
retoucher1444543__retoucher
retouches1445903__retouches
unreached1536883unre__ached
cartouche16122564car_touche_
cartouches17112954car_touches
crouched16359144_cr__ouched
debouched18123634__debouched
grouched15356664_gr__ouched
mistouched1843104_mistouched
retched133814274__ret__ched
retouch1235854__retouch__
retouchers1543484__retouchers
stretched1546214stret__ched
touched134914964____touched
unattached1642714un_attached
unbreeched1842784unbre__eched
undetected1444874undet_ected
unenriched1642564un_enriched
unhatched1844134unhat__ched
unhitched1843094unhit__ched
unlatched1544214unlat__ched
unmatched1744204unmat__ched
unpatched1744054unpat__ched
unrebuked1652674unre_bu_ked
unreconciled1751804unreconciled
unrecorded1443134unreco_rded
unrecovered1752374unrecovered
unreformed1643564unrefo_rmed
unreported1344074unrepo_rted
unrequited2043424unre_quited
unresolved1442654unreso_lved
unrestored1165114unresto__red
unrestricted1553504unrestricted
unretired1046434unret__ired
unrevoked1743424unrevo__ked
unrounded1135864unr__ounded
unrushed12247574unr___ushed
unstitched1643514un_stitched
unstocked1645064un_sto_cked
untucked15206054un__t_ucked
unwatched1844084unwat__ched
upreached1764084upre__ached
wretched17276534_wret__ched

Search took 9 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 Filter1786911488190.420425454.8
2DLD Change Limit148819468.42317668.2
3Display Results46460.0301533.3
 (SQL Overall)178691468.87320138.7
 
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.