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

72 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
retouching164469(None) 
debouching1942722debouching
retching143412172ret__ching
reteaching1636022reteaching
touching143211342__touching
avouching1843273_avouching
couching163213263__couching
crouching1746383_crouching
debauching1942473debauching
detaching1637263det_aching
detouring1136973detou_ring
douching15349843__douching
etching134511843_et__ching
fetching17298413fet__ching
grouching1644943_grouching
letching143810263let__ching
mistouching1942993mistouching
mouching163110583__mouching
ouching134314903___ouching
pouching163210413__pouching
reaching143317203re__aching
reattaching1743123reattaching
rebounding1435303rebounding
recocking18138373reco_cking
recounting1339193recounting
recouping1438363recou_ping
recoupling1545043recoupling
redocking17126783redo_cking
redoubling1443433redoubling
redounding1345213redounding
reducing12310203re_duc_ing
refocusing1653853refocusing
refounding1545353refounding
rehousing1337253rehou_sing
rejoicing19136943rejoic_ing
relaunching1742243relaunching
relocking16137683relo_cking
relucting1239773re_lucting
rematching1844913rematching
remounting1346673remounting
renouncing1345103renouncing
repatching1844993repatching
repouring12310073repou_ring
reproaching1944303reproaching
rerouting10311873rerou_ting
resounding1236363resounding
restitching1744003restitching
restocking1745703resto_cking
retacking1658973ret_acking
retooling1039093reto_oling
retorting10613273reto_rting
retotaling1186883retotaling
retouch1235863retouch___
retouched1545113retouch_ed
retoucher1444543retouch_er
retouchers1543483retouchers
retouches1445903retouch_es
retracing12313293retrac_ing
retracking1738163retracking
retracting13311933retracting
retrenching1743913retrenching
retroacting1447283retroacting
retuning9311583ret_u_ning
returning1038133ret_urning
revoicing15117713revoic_ing
roaching143210433r__oaching
roughing13278343r__oughing
ruching133612933r___uching
slouching15195723_slouching
torching142510083__torching
toughing13278553__toughing
vouching17308233__vouching

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 Filter1786911406030.423422437.4
2DLD Change Limit140603725.97023551.6
3Display Results72720.0302400.0
 (SQL Overall)178691726.42327820.5
 
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.