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

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

101 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
hatches15342027(None) 
batches144019611batches
catches144320771catches
hatched163414461hatched
hatchel153510751hatchel
hatchels16368671hatchels
hatcher153314721hatcher
hatchers163113171hatchers
hatchet153317561hatchet
hatchets163310381hatchets
hitches153616271hitches
hotches153814361hotches
hutches153613521hutches
latches123320131latches
matches143219781matches
patches143320381patches
ratches123620461ratches
thatches1637511thatches
watches153017371watches
aches106132292_a_ches
aitches123014362aitches
arches114822042_arches
baches135426942ba_ches
batched154114242batched
batcher144414852batcher
batchers153613272batchers
bathes116524832bat_hes
bitches144117062bitches
botches143716022botches
butches144315362butches
caches137926912ca_ches
catcher143115822catcher
catchers153114062catchers
chatchkes23174742chatchkes
cratches153012542cratches
cutches143216462cutches
datchas1347422datchas
ditches133215712ditches
etches114217762_etches
fetches153413892fetches
fitches153516192fitches
hances115621282hanc_es
hashes125024802ha_shes
hatch135719592hatch__
hatcheck2244012hatcheck
hatchecks2343592hatchecks
hatchery19326382hatchery
hates86742572hat__es
haunches1656962haunches
hitched163312252hitched
hitcher153712002hitcher
hitchers16379992hitchers
hooches153812522hooches
hootches1656972hootches
hotched163610922hotched
hunches153913462hunches
hutched16359882hutched
itches114916212_itches
ketches164012192ketches
klatches17157142klatches
laches116528352la_ches
larches124416452larches
latched133914072latched
latchet123117912latchet
latchets133410012latchets
lathes95127502lat_hes
letches124015482letches
maches134827232ma_ches
manches143818622manches
marches143921172marches
matched153513962matched
matcher143214282matcher
matchers153012432matchers
mutches143314282mutches
naches114622412na_ches
nautches1336082nautches
notches123513652notches
parches143720002parches
patched153514622patched
patcher143515142patcher
patchers153413302patchers
pitches143617752pitches
ranches123620112ranches
ratchet124218332ratchet
ratchets133110262ratchets
retches123318512retches
rotches123515702rotches
satchel123310302satchel
satchels13328162satchels
slatches131511532slatches
snatches131410712snatches
swatches16169962swatches
taches114224172ta_ches
thatched1735432thatched
thatcher1635662thatcher
thatchers1744582thatchers
vetches153411262vetches
watched163012822watched
watcher153113402watcher
watchers163511792watchers
witches152715792witches

Search took 4 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 Filter1786911076710.373479064.3
2DLD Change Limit1076711013.42331455.2
3Display Results1011010.0462195.7
 (SQL Overall)1786911013.84246509.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.