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

113 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
hatracks173753(None) 
hatrack1638211hatrack_
hayracks2045311hayracks
amtracks1696632amtracks
arracks1387732_arracks
attacks13126942_attacks
barracks1636882barracks
caracks152211562ca_racks
carracks1637712carracks
coatracks1745402coatracks
fatbacks1946002fatbacks
halftracks22102102halftracks
hayrack1945542hayrack_
hayricks2043762hayricks
retracks14149102retracks
tracks124818842__tracks
untracks1437522untracks
whitracks2142942whitracks
amtrack15107393amtrack_
amtracs1198883amtrac_s
araks94820883_a_ra_ks
arrack121110253_arrack_
attack12148153_attack_
attracts1047793attracts
backtracks1943543backtracks
barrack1538253barrack_
calpacks18266523calpacks
caprocks1835943caprocks
carack142113173ca_rack_
carjacks2345573carjacks
carrack1548753carrack_
cataracts1345583cataracts
catfaces1536963catfaces
catwalks1744793catwalks
coatrack1645853coatrack_
cracks144817003__cracks
cutbacks1845813cutbacks
detracts11138833detracts
extracts1747623extracts
fastbacks2044253fastbacks
fatback1836923fatback_
hacks144928713h___acks
haddocks1984903haddocks
haircaps15144363haircaps
hairlocks1863773hairlocks
halfbacks2343993halfbacks
halftrack21122413halftrack_
hammocks2164343hammocks
harass9313943ha_ra_ss
hardbacks2145373hardbacks
hardhacks2243703hardhacks
hardpacks2143623hardpacks
hardtacks1943803hardtacks
harks126333433ha_r__ks
hartals10313023harta_ls
hassocks1744693hassocks
hatbands1446293hatbands
hatchbacks2683083hatchbacks
hatchecks2343593hatchecks
hatreds11307813hatr_eds
haversacks2252213haversacks
haycocks2244113haycocks
hayrick1944183hayrick_
haystacks2143373haystacks
headraces1546613headraces
hijacks2333533h_ijacks
hogbacks2044853hogbacks
hopsacks1944733hopsacks
hyraces1537913h_yraces
lavrocks1743663lavrocks
maracas11313773ma_racas
matrass939403matra_ss
matrices12312083matrices
mattocks1644983mattocks
outbacks1638983outbacks
outraces102217863outraces
outranks12298823outranks
outrocks1437903outrocks
patacas11311003pat_acas
paybacks2145493paybacks
racetracks1853003racetracks
racks115028853___racks
ransacks1445773ransacks
reattacks1543753reattacks
reracks132310533_reracks
retacks132210713ret_acks
retraces101417273retraces
retrack131310723retrack_
retracts101111313retracts
satraps95011643satra_ps
scatbacks1974713scatbacks
seatbacks17115603seatbacks
setbacks1686303setbacks
shadrachs1843303shadrachs
shamrocks2043033shamrocks
stacks124317263_st_acks
stricks134310693_stricks
tacks115430133__t_acks
tamaracks1743753tamaracks
thacks154311923__thacks
traces85329933__traces
track114823013__track_
tracts85019073__tracts
traiks104013713__traiks
tranks104017763__tranks
tricks125319013__tricks
trocks123614633__trocks
trucks124711973__trucks
untacks1357503unt_acks
untrack1338703untrack_
wetbacks1974983wetbacks
whitrack2043533whitrack_
wracks154711113__wracks

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 Filter1786911461620.466383457.1
2DLD Change Limit1461621137.61019206.6
3Display Results1131130.0462456.5
 (SQL Overall)1786911138.12222000.9
 
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.