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

460 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
hatched16341446(None) 
batched154114241batched
hatchel153510751hatchel
hatcher153314721hatcher
hatches153420271hatches
hatchet153317561hatchet
hitched163312251hitched
hotched163610921hotched
hutched16359881hutched
latched133914061latched
matched153513961matched
patched153514621patched
thatched1735431thatched
watched163012821watched
ached119227832_a_ched
arched125717322_arched
bached145519892ba_ched
batcher144414852batcher
batches144019612batches
bathed125518742bat_hed
bitched153212922bitched
botched153611902botched
cached145419202ca_ched
catcher143115822catcher
catches144320762catches
ditched143711902ditched
etched123613702_etched
fetched163710472fetched
hacked164923512ha_cked
hashed136021942ha_shed
hatch135719592hatch__
hatcheck2244012hatcheck
hatcheled1844222hatcheled
hatchels16368672hatchels
hatchers163113172hatchers
hatchery19326382hatchery
hatchets163310382hatchets
hated95734022hat__ed
hatred104814332hat_red
hatted104921512hat_ted
haunched1744812haunched
hitcher153712002hitcher
hitches153616272hitches
hotches153814362hotches
hunched163710492hunched
hutches153613522hutches
itched123812022_itched
latches123320122latches
latchet123117902latchet
lathed104718452lat_hed
letched133912052letched
marched153813402marched
matcher143214282matcher
matches143219782matches
notched134210302notched
parched154013692parched
patcher143515142patcher
patches143320382patches
pitched153512922pitched
ranched133113602ranched
ratches123620462ratches
ratchet124218332ratchet
retched133814272retched
satchel123310302satchel
snatched14157632snatched
tetched133010772tetched
thatcher1635652thatcher
thatches1637512thatches
unhatched1844132unhatched
watcher153113402watcher
watches153017372watches
witched163012192witched
aahed917816443_a_ahed
aced79540883_a_c_ed
ache96829823_a_che_
aches106132293_a_ches
acned87520663_a_cned
acred87126353_a_cred
acted88521733_a_cted
ahed89536253_a__hed
aitches123014363aitches
arced88224163_arc_ed
archer115016243_archer
arches114822043_arches
arcked136211943_arcked
ashed97829773_a_shed
atoned75417543_atoned
attached14165703attached
baches135426943ba_ches
backed155725723ba_cked
bashed126225703ba_shed
batch124620103batch__
batchers153613273batchers
bated85935533bat__ed
bathe105822883bat_he_
bather115322513bat_her
bathes116524833bat_hes
batiked1435963batiked
batted95623653bat_ted
battled104213123battled
beached154516553beached
belched154011843belched
benched154713943benched
birched15349913birched
bitchen14349733bitchen
bitches144117063bitches
blanched16308603blanched
blotched1635653blotched
botcher143613223botcher
botches143716023botches
branched163210453branched
bunched154312413bunched
butcher143411163butcher
butches144315363butches
caboched1844043caboched
cache125122483ca_che_
caches137926913ca_ches
cachet134526413ca_chet
capuched1843743capuched
cashed125124353ca_shed
catch125120373catch__
catchers153114053catchers
catchier15329863catchier
catchup1644783catchup
catchy16559583catch_y
catered103117763catered
cathead1338753cat_head
catted95422473cat_ted
chanced154113213chanc_ed
chatchka22202893chatchka
chatchke22153883chatchke
chatchkes23174743chatchkes
chatted133411893chat_ted
churched1934653churched
cinched153910863cinched
cliched153711023cliched
clutched16356033clutched
coached153313843coached
couched154115793couched
cranched163210413cranched
cratches153012543cratches
crotched16428593crotched
crutched16307463crutched
cutches143216453cutches
danced105315253danc_ed
dashed115920563da_shed
datcha1266563datch_a
datchas1347423datchas
dated75530993dat__ed
detached1537733detached
dethatched2042533dethatched
ditcher134012003ditcher
ditches133215713ditches
douched144012113douched
earthed1139923earthed
eched116919223__eched
etcher113912943_etcher
etches114217763_etches
faced117727653fa_c_ed
faithed1437163faithed
fancied133310603fancied
farced125216533farc_ed
fashed136720253fa_shed
fated95632133fat__ed
fathead1437863fat_head
father125116713fat_her
fatted105419843fat_ted
fetcher153510393fetcher
fetches153413893fetches
filched16307423filched
fitchee152710783fitchee
fitches153516193fitches
fitchet153113563fitchet
fitchew18276803fitchew
fletched17306693fletched
flitched17256293flitched
gashed116321973ga_shed
gated75329773gat__ed
gather104115853gat_her
gauche1238553gauche_
gaucher1337233gaucher
grutched15284673grutched
habited1337883habited
hacek145411843ha_c_ek
hachured1744393ha_chured
hackee154921833ha_ckee
hacker154822693ha_cker
hackled173312483hackled
haded105227623ha__ded
haed86338583ha___ed
hafted134713833ha_fted
hagged124317703ha_gged
haggled13359283haggled
hailed104122743ha_iled
haired105117173ha_ired
haled95335823ha__led
halloed113314913halloed
haloed104717593ha_loed
halted105019603ha_lted
haltered123112553haltered
halved134813903ha_lved
hammed144116973ha_mmed
hance105424153hanc_e_
hances115621283hanc_es
handed114919983ha_nded
handheld1644463handheld
handled124114533handled
hanged114222393ha_nged
hanked144220603ha_nked
hanted104124313ha_nted
happed144820103ha_pped
hardhead1645883hardhead
hared95742183ha__red
harked145422553ha_rked
harmed125218833ha_rmed
harped124418403ha_rped
harried113815533harried
harshen1339283harshen
harsher13310363harsher
hashes125024803ha_shes
hashhead1443263hashhead
hasped125014443ha_sped
hassled11358303hassled
hasted105125283ha_sted
hastened12239103hastened
hatband1346823hatband
hatchecks2343593hatchecks
hatchelled1943013hatchelled
hatching173312213hatching
hatchment1945313hatchment
hatchway2243293hatchway
hate78450173hat__e_
hater85034753hat__er
hates86742573hat__es
hath105933913hat_h__
hatreds11307813hat_reds
hatter94724873hat_ter
hauled104415213ha_uled
haunches1656963haunches
haunted11399733haunted
havened14429243havened
havered144011453havered
havocked2142323havocked
hawed126025423ha__wed
hawked174712673ha_wked
hayed125822013ha__yed
hayseed1435633hayseed
hazed185222203ha__zed
heated104525593heat__ed
heathen133410893heat_hen
heather133914853heat_her
hitch134515473hitch__
hitchers16379993hitchers
hither124417253hit_her
hocked165521303h_ocked
hoicked1735963hoicked
honchoed1745733honchoed
hooches153812523hooches
hootches1656973hootches
hotbed123310673hot_bed
hotch136214723hotch__
hothead14349293hot_head
hotted104319933hot_ted
humphed1835423humphed
hunches153913463hunches
hushed134416673h_ushed
hutch135414093hutch__
hutted104616333hut_ted
inarched1486113inarched
inched124514483_inched
itches114916213_itches
jacked204817523ja_cked
ketches164012193ketches
kitchen16287683kitchen
kithed144613013kit_hed
klatches17157133klatches
kvetched2142783kvetched
kythed17407313kyt_hed
laced87132643la_c_ed
laches116528343la_ches
lacked135324653la_cked
lanced93717723lanc_ed
larchen12479623larchen
larches124416443larches
lashed105625213la_shed
latch104620463latch__
latchets133410013latchets
latchkey2042913latchkey
lated65240673lat__ed
latened8711923latened
lathe85626713lat_he_
lather95124353lat_her
lathes95127493lat_hes
laughed1235893laughed
launched1475403launched
leached133715043leached
leched123716003_leched
leeched13369503leeched
letches124015483letches
loathed11419443loat_hed
lunched133911823lunched
lurched13358033lurched
lynched16376753lynched
maced108528693ma_c_ed
mache125925303ma_che_
maches134827233ma_ches
macled116718113ma_cled
manche133515103manche_
manches143818623manches
manchet143317773manchet
marchen143312073marchen
marcher143912973marcher
marches143921173marches
mashed125325043ma_shed
match125621103match__
matchers153012433matchers
matchup1643513matchup
mated85537783mat__ed
matted94521413mat_ted
matured10310033matured
miched143913393_miched
mooched153910533mooched
mouched153612593mouched
mulched15307763mulched
munched153411073munched
mutches143314283mutches
naches114622413na_ches
nacred95212493na_cred
natch105018223natch__
natured838963natured
nautches1336073nautches
niched125514063_niched
notcher123610933notcher
notches123513653notches
ouched124316933_ouched
outchid1338723outchid
paced106931683pa_c_ed
packed154822603pa_cked
parches143720003parches
pashed125923143pa_shed
patch125221223patch__
patchers153413303patchers
patchier15319663patchier
patchy16509573patch_y
pated85237843pat__ed
patined105114783patined
patted94724683pat_ted
paunched1645523paunched
peached154315883peached
peched144915343_peched
perched154713233perched
pinched153812453pinched
pitcher143813713pitcher
pitches143617753pitches
pithed124615613pit_hed
poached154212403poached
pooched152810083pooched
pouched153612773pouched
psyched1843913psyched
punched153512173punched
raced87635313ra_c_ed
rachet115028973ra_chet
racked134526083ra_cked
ralphed1334363ralphed
rancher123013633rancher
ranches123620113ranches
ratch104221363ratch__
ratcheted1554783ratcheted
ratchets133110263ratchets
rated65441383rat__ed
rathe85821923rat_he_
rather94319733rat_her
ratted74923343rat_ted
rattled84012953rattled
reached134619083reached
rematched1745223rematched
repatched1745313repatched
retches123318513retches
roached133211833roached
rotche114311983rotche_
rotches123515703rotches
ruched124314633_ruched
sachem134012223sa_chem
sachet114725773sa_chet
sacked135525213sa_cked
sacred94917103sa_cred
sashed105622943sa_shed
satcheled1544423satcheled
satchels13328163satchels
sated66238533sat__ed
sauced93913303sauc_ed
scathed134012643scat_hed
schatchen1943853schatchen
scotched16187933scotched
scratched1735383scratched
scutched16186893scutched
searched14209253searched
shacked174015393sha_cked
sheathed1547213sheat_hed
sketched1835393sketched
slatches131511523slatches
smutched16165923smutched
snatcher13167753snatcher
snatches131410713snatches
snitched14166863snitched
spathed134013183spat_hed
stacked143416123stacked
stanched14208903stanched
starched14199313starched
stashed113812483stashed
stitched14148203stitched
swatches16169963swatches
swathed144611933swat_hed
switched17157133switched
synched16277213synched
tache106222373ta_che_
taches114224173ta_ches
tacked134723943ta_cked
talced93811003talc_ed
talcked1446343talcked
tatted74920533tat_ted
tattled84311483tattled
teched124014433_teched
thacked173810203tha_cked
thatch1435603thatch__
thatchers1744573thatchers
thatchier1743983thatchier
thatchy1833303thatch_y
tithed104115593tit_hed
torched133511353torched
touched134914963touched
twitched17155033twitched
tythed13457503tyt_hed
unarched14128553unarched
unhitched1843093unhitched
unlatched1544213unlatched
unmatched1744203unmatched
unpatched1744053unpatched
unwatched1844083unwatched
vatted104214733vat_ted
vetches153411263vetches
vouched163910563vouched
washed135521503wa_shed
watch135617063watch__
watchers163511793watchers
watcheye19104273watcheye
watchmen1844753watchmen
watered113014953watered
wattled113610503wattled
wauchted1753373wauchted
welched16298833welched
wenched163910913wenched
whacked20458623wha_cked
winched163110593winched
witches152715793witches
withed134416233wit_hed
wrathed14298523wrat_hed
wretched17276533wretched
yachted1634853ya_chted
yacked164516793ya_cked

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.1561145455.1
2DLD Change Limit1340274608.31316122.6
3Display Results4604600.1533006.5
 (SQL Overall)1786914608.62220725.0
 
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.