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

188 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
thatched173543(None) 
hatched163414461_hatched
thatcher1635651thatcher
thatches1637511thatches
batched154114242_batched
dethatched2042532dethatched
hatchel153510752_hatchel
hatcher153314722_hatcher
hatches153420272_hatches
hatchet153317562_hatchet
hitched163312252_hitched
hotched163610922_hotched
hutched16359882_hutched
latched133914062_latched
matched153513962_matched
patched153514622_patched
snatched14157632snatched
tetched133010772t_etched
thacked173810202tha_cked
thatch1435602thatch__
thatchers1744572thatchers
thatchier1743982thatchier
thatchy1833302thatch_y
twitched17155032twitched
unhatched1844132unhatched
watched163012822_watched
ached119227833__a_ched
arched125717323__arched
attached14165703atta_ched
bached145519893_ba_ched
batcher144414853_batcher
batches144019613_batches
bathed125518743_bat_hed
beached154516553bea_ched
bitched153212923_bitched
blanched16308603blanched
blotched1635653blotched
botched153611903_botched
branched163210453branched
cached145419203_ca_ched
catcher143115823_catcher
catches144320763_catches
chanced154113213chanc_ed
chatchka22202893chatchka
chatchke22153883chatchke
chatchkes23174743chatchkes
chatted133411893chat_ted
churched1934653churched
clutched16356033clutched
coached153313843coa_ched
cranched163210413cranched
cratches153012543cratches
crotched16428593crotched
crutched16307463crutched
detached1537733detached
dethatches1943193dethatches
ditched143711903_ditched
etched123613703__etched
fetched163710473_fetched
fletched17306693fletched
flitched17256293flitched
grutched15284673grutched
hacked164923513_ha_cked
hashed136021943_ha_shed
hatch135719593_hatch__
hatcheck2244013_hatcheck
hatcheled1844223_hatcheled
hatchels16368673_hatchels
hatchers163113173_hatchers
hatchery19326383_hatchery
hatchets163310383_hatchets
hated95734023_hat__ed
hatred104814333_hat_red
hatted104921513_hat_ted
haunched1744813_haunched
hitcher153712003_hitcher
hitches153616273_hitches
hotches153814363_hotches
hunched163710493_hunched
hutches153613523_hutches
inarched1486113inarched
itched123812023__itched
klatches17157133klatches
kvetched2142783kvetched
latches123320123_latches
latchet123117903_latchet
lathed104718453_lat_hed
leached133715043lea_ched
letched133912053_letched
loathed11419443loat_hed
marched153813403_marched
matcher143214283_matcher
matches143219783_matches
notched134210303_notched
nuthatches1842393nuthatches
outmatched1843483outmatched
outwatched1943423outwatched
parched154013693_parched
patcher143515143_patcher
patches143320383_patches
peached154315883pea_ched
pitched153512923_pitched
poached154212403poa_ched
potlatched18112453potlatched
ranched133113603_ranched
ratches123620463_ratches
ratchet124218333_ratchet
reached134619083rea_ched
rematched1745223rematched
repatched1745313repatched
retched133814273_retched
roached133211833roa_ched
satchel123310303_satchel
scathed134012643scat_hed
schatchen1943853schatchen
scotched16187933scotched
scratched1735383scratched
scutched16186893scutched
searched14209253searched
shacked174015393sha_cked
sheathed1547213sheat_hed
sketched1835393sketched
slatches131511523slatches
smutched16165923smutched
snatcher13167753snatcher
snatches131410713snatches
snitched14166863snitched
spathed134013183spat_hed
stanched14208903stanched
starched14199313starched
stitched14148203stitched
stretched1546203stretched
swatches16169963swatches
swathed144611933swat_hed
switched17157133switched
tache106222373t_a_che_
taches114224173t_a_ches
tacked134723943t_a_cked
talced93811003t_alc_ed
talcked1446343t_alcked
tatted74920533t_at_ted
tattled84311483t_attled
teacher123714833tea_cher
teaches122718353tea_ches
teated74924023teat__ed
teched124014433t__eched
teethed11318623teet_hed
thanked15469153tha_nked
thatchiest1844163thatchiest
thatching1835143thatching
thawed13458463tha__wed
thighed1535263th_ighed
thither13328103thit_her
thrashed1555363thrashed
threshed1535643threshed
thwacked2132723thwacked
tithed104115593t_it_hed
toothed113310243toot_hed
torched133511353t_orched
touched134914963t_ouched
traced94821583tra_c_ed
trachea12311673tra_chea
tracheid1437583tra_cheid
trachled1438313tra_chled
tracked143716133tra_cked
tranced104414173tranc_ed
tranche123312223tranche_
tranches132915513tranches
trashed113514693tra_shed
trauchled1543733trauchled
trenched14289853trenched
trothed114010973trot_hed
twattled1273463twattled
twitcher16135343twitcher
twitches16156373twitches
tythed13457503t_yt_hed
unarched14128553unarched
unhitched1843093unhitched
unlatched1544213unlatched
unmatched1744203unmatched
unpatched1744053unpatched
unwatched1844083unwatched
watcher153113403_watcher
watches153017373_watches
whacked20458623wha_cked
witched163012193_witched
wrathed14298523wrat_hed
wretched17276533wretched

Search took 10 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.1561145455.1
2DLD Change Limit1461621889.01616211.4
3Display Results1881880.0762473.7
 (SQL Overall)1786911889.24819322.1
 
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.