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

125 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
hatrack163821(None) 
hatracks1737531hatracks
hayrack1945541hayrack
amtrack15107392amtrack
arrack121110252_arrack
attack12148152_attack
barrack1538252barrack
carack142113172ca_rack
carrack1548752carrack
coatrack1645852coatrack
fatback1836922fatback
halftrack21122412halftrack
hayracks2045312hayracks
hayrick1944182hayrick
retrack131310722retrack
track114823012__track
untrack1338702untrack
whitrack2043532whitrack
aback134816173_a_back
alack114820063_a_lack
amtrac10109123amtrac_
amtracks1696633amtracks
amtracs1198883amtracs
arak86929573_a_ra_k
arracks1387733_arracks
attach11118393_attach
attacks13126943_attacks
attract9511833attract
backtrack1844243backtrack
barracks1636883barracks
calpack17338333calpack
caprock1736813caprock
caracks152211563ca_racks
carjack2246153carjack
carracks1637713carracks
cataract1249413cataract
catface1436763catface
catwalk1645323catwalk
coatracks1745403coatracks
crack134120533__crack
cutback1747093cutback
detract101414633detract
extract16311013extract
fastback1944523fastback
fatbacks1946003fatbacks
hack135134543h___ack
haddock1885583haddock
haircap14134753haircap
hairlock1754023hairlock
halfback2244243halfback
halftracks22102103halftracks
hammock2064633hammock
harass9313943ha_rass
hardback2045633hardback
hardhack2143843hardhack
hardpack2043923hardpack
hardtack1843993hardtack
hark115237393ha_r__k
hartal9415473harta_l
hartals10313023hartals
hassock1645443hassock
hatband1346823hatband
hatch135719593hat__ch
hatchback2563313hatchback
hatcheck2244013hatcheck
hatred104814333hatr_ed
hatreds11307813hatreds
haversack2142383haversack
haycock2144313haycock
hayricks2043763hayricks
haystack2044013haystack
headrace1446663headrace
hijack2233673h_ijack
hogback1945453hogback
hopsack1845273hopsack
iatric8312163iatric_
lavrock1644223lavrock
manpack1746063manpack
maraca10314153ma_raca
matrass939403matrass
mattock1535823mattock
offtrack2042323offtrack
ostraca937823ostraca
outback15310653outback
outrace92418553outrace
outrank112611973outrank
outrock1339303outrock
pataca10311193pat_aca
payback2056453payback
racetrack1743493racetrack
rack106234883___rack
ransack1346463ransack
reattack1444123reattack
rerack122513163_rerack
retack122612823ret_ack
retrace91417343retrace
retracks14149103retracks
retract91318113retract
satrap86212553satra_p
satraps95011643satraps
satrapy12497933satrapy
scatback1875033scatback
seatback1675823seatback
setback1567143setback
shadrach1743973shadrach
shamrock1943473shamrock
stack114421693_st_ack
strick124813203_strick
struck12489263_struck
tack106536293__t_ack
tamarack1644363tamarack
thack144915173__thack
trace75829613__trace
tracks124818843__tracks
tract75635713__tract
traik95418203__traik
trank96222423__trank
trick115420693__trick
trock114817603__trock
truck116115463__truck
untack1239763unt_ack
untracks1437523untracks
wetback1875613wetback
whitracks2142943whitracks
wrack145413883__wrack

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271257.59317651.4
3Display Results1251250.0462717.4
 (SQL Overall)1786911258.06222164.6
 
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.