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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

112 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
retouch123585(None) 
debouch15124252debouch
retch104818302ret__ch
reteach1237412reteach
retouched1545112retouched
retoucher1444532retoucher
retouches1445902retouches
touch106519392__touch
avouch1434833_avouch
capouch1644413capouch
cartouch15113493cartouch
couch125320113__couch
crouch133910203_crouch
debauch15134423debauch
debouche16123773debouche
detach12310413det_ach
detour778193detou_r
detours858033detours
enough1045753_enough
epoch1248203_epo_ch
etch95419143_et__ch
eunuch1154363_eunuch
fetch134913473fet__ch
fetich1479693fet_ich
grouch12318473_grouch
heuch135312333he__uch
ketch144912023ket__ch
letch105215803let__ch
lettuce943323lettuce
mistouch1543793mistouch
mouch124715803__mouch
ouch95724633___ouch
pouch124617083__pouch
ratch104221363rat__ch
reach105123883re__ach
reattach1343743reattach
rebought1474393rebought
rebound1058583rebound
recock145112723reco_ck
recount9315173recount
recoup10810373recou_p
recoupe11109933recoupe
recoups1188843recoups
redock134311543redo_ck
redoubt10167843redoubt
redound968173redound
redout71820253redou_t
redouts81411653redouts
reduce9713253re_duce
refocus1236973refocus
refought1564233refought
refound1157413refound
rehouse10311773rehouse
rejoice16287453rejoice
relaunch1352803relaunch
relock124713523relo_ck
reluct83916113re_luct
rematch1436193rematch
remount9512283remount
renounce1047403renounce
repatch1435843repatch
repour8310993repou_r
repours9310223repours
reproach1544953reproach
reroute7313963reroute
resought1254983resought
resound869263resound
resource1046313resource
restitch1344693restitch
restock1338673resto_ck
restruck1445223restruck
retack122612823ret_ack
retaught1244653retaught
rethought1653803rethought
retold73013753reto_ld
retook104313443reto_ok
retool63914483reto_ol
retools73411023retools
retore67630763reto_re
retorn610923423reto_rn
retort66831143reto_rt
retorts76016513retorts
retotal739843retotal
retouchers1543473retouchers
retouching1644693retouching
retrace91417343retrace
retrack131310723retrack
retract91318113retract
retrench1346283retrench
retroact10410003retroact
retune69121953ret_une
return623222523ret_urn
retuse66617223ret_use
revoice12319183revoice
rewound1156433rewound
roach105717003r__oach
rotch105815933r__otch
rouche114714313r__ouche
rough97819433r__ough
routh86423073r__outh
setous64917373setou_s
setout64719463setou_t
setouts74110333setouts
slouch11438523_slouch
teuch105214853__teuch
torch107420933__torch
touche114916173__touche
touchy145010503__touchy
tough97321983__tough
vetch134411843vet__ch
vouch134611903__vouch
wretch14326533wret__ch

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.1561145455.1
2DLD Change Limit1340271126.84319586.0
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.04525364.2
 
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.